Transpose without copy and paste

[SSS777]

I have 2 sheets. The information on sheet 1 is in rows. I want to get that info on sheet two in colums.


Sheet 1 sheet 2
1 1 2 3 4 5
2
3
4
5


So the info is on sheet two and I want in like in sheet 1. I do not want to transpose as the info on sheet 2 is not yet filled in. It is info for 2013. I want the info to pull through automatically to sheet 1 as per obove.

Please help

[SSS777]

See attached sample

[kvsrinivasamurthy]

PL see attached file with formula.

[SSS777]

Thanks a lot

[domfootwear]

I have 2 sheets. The information on sheet 1 is in rows. I want to get that info on sheet two in colums.


Sheet 1 sheet 2
1 1 2 3 4 5
2
3
4
5


So the info is on sheet two and I want in like in sheet 1. I do not want to transpose as the info on sheet 2 is not yet filled in. It is info for 2013. I want the info to pull through automatically to sheet 1 as per obove.

Please help

You can use function

Please Login or Register  to view this content.