Changing column and row ID's

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have about 5 spreadsheets with 60 rows and 30 columns of data in each sheet (mostly numbers). I would would like to copy this data in a landscape format (imagine visually as rotating the data 90 degrees counter clockwise - not transposing the rows and columns using pastespecial -> transpose). u could imagine it as swapping the row id's with column id's .is it possible to do this in excel.if not is it possible to copy it in word and then rotate the spreadsheet. i hope i am clear.

thanks
 
So you want the value from AD1 to end up in A1 and that from A1 to end up in
A30. AD2 ends up in B1, etc.

Edit/Copy the data, Edit/Paste Special, Transpose somewhere else, say to A1 on
another sheet. On that new sheet, insert a new column A and fill it with the
sequential numbers 1-30. Sort descending on column A, then delete it.

I have about 5 spreadsheets with 60 rows and 30 columns of data in each sheet
Click to expand...
(mostly numbers). I would would like to copy this data in a landscape format
(imagine visually as rotating the data 90 degrees counter clockwise - not
transposing the rows and columns using pastespecial -> transpose). u could
imagine it as swapping the row id's with column id's .is it possible to do
this in excel.if not is it possible to copy it in word and then rotate the
spreadsheet. i hope i am clear.
 
Back
Top