Excel - Data in Rows instead of columns ???? 6

[LooneyToon]

Lads,

I have data and it is all in "Rows", ie. The headers of the data are in rows (along the side), instead of in Columns(along the top). My problem is that I need to tranfer this data so that the Headers are in the Columns and that the data is in the rows. Does anybody know of a quick way to do this ?


Cheers
Mick

 

[VulcanJedi]

highlight all the data, click COPY,
then goto another sheet, or away from the current data and select PASTE SPECIAL, select the option, TRANSPOSE Tranpkp
************************************
- Let me know if this helped/worked!
Please remember to give helpful posts the stars they deserve!
This facilitates navigating threads / posts!

 

[LooneyToon]

You friggin GENIUS!!!!!

That has just saved me HOURS of work!!!

Thanks a million!!

 

[xlhelp]

Highlight all the cells you need; go to Edit, Copy; go to another Worksheet or blank area of the current worksheet; go to Edit, Paste Special, select Transpose and click OK.

If you go to blank area of the worksheet you need to make sure there is enough room to fit the data.

 

[xlhelp]

I guess Tranpkp types faster than I do.

 

[LooneyToon]

Thanks a million xlhelp!!!!!

I is one happy camper now!

 

[SF0751]

Just another reason why Tek-Tips is GREAT! This has been bugging me for a long time; but I never took the time to figure it out! Stars for everyone!

Susan
Under certain circumstances, profanity provides a relief denied even to prayer. - Mark Twain