Reverse a spreadsheet reversing columns and rows?

B

Becca

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.
 
W

William Horton

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
 
R

RagDyer

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!
 
G

Gord Dibben

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
 
Top