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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I reverse the axes of a populated worksheet (X to Y, Y to X)? 4
Look up a value from a row after verifying two other values 10
Can I invert a table so row headings are now column headings etc 3
Excel function to reverse the order of rows in a spreadsheet 3
reverse or invert column data 1
Reversing a column 2
Comparing figures across 2 columns. 7
How Do I reverse axis in a spreadsheet 3

Back
Top