turn columns into rows

C

chippy

I have a large spreadsheet that I'd like to have in two separate formats:
One, with Data X in Columns and Data Y in Rows, the other with Data Y in
Columns and Data X in Rows. How can I do this while preserving the data?
 
R

RagDyeR

Select data, right click, choose "Copy".

Right click in first cell of new location, choose "Paste Special", and click
on "Transpose", then <OK>.

Don't forget ... you only have 256 columns.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a large spreadsheet that I'd like to have in two separate formats:
One, with Data X in Columns and Data Y in Rows, the other with Data Y in
Columns and Data X in Rows. How can I do this while preserving the data?
 
Top