Displaying values in Column & rows ?

Dear All,

I am attaching a excel in which i have in TAB A , Capabilities & Score in Rows 1 & 2. I want to display the same value in TAB B , in Columns A & B.

Dragging is not working in this case. Also i do not want to copy and paste it through transpose option because capabilities and score will keep on updating.

Please help.

Regards
Mohammad

Put this in A2 of Tab B:

=INDEX(A!$1:$1,ROW())

and this in B2:

=INDEX(A!$2:$2,ROW())

then copy both down.

Hope this helps.

Pete