Reverse a spreadsheet reversing columns and rows?

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

Guest

I have a spreadsheet witn 30 columns and 15 rows with data and want to flip
it so that the columns become the rows and vice versa.
 
Try using Excel's TRANSPOSE function. Look it up in Excel help. Remember to
enter the formula with the Control-Shift-Enter keys (Not just the enter key
by itself). You also have to select a range of cells for the answer.

Hope this helps.

Bill Horton
 
Select your *entire* datalist, say A1 to AD15.

Right click in the selection and choose "Copy".

Now, right click in the top left cell of the *new* location (*no* overlap),
OR ... navigate to another sheet,
Then choose "Paste Special",
Click on "Transpose", then <OK>,
And you're done!
 
Copy the range of Data.

Select a cell that will not be overwritten well away from that range or insert a
new sheet.

Edit>Paste>Special>Transpose>OK>Esc


Gord Dibben MS Excel MVP
 
Back
Top