Warning

 

Close

Confirm Action

Are you sure you wish to do this?

Confirm Cancel
Member Login

Site Notices
Posted: 7/20/2010 4:56:04 AM EST
Is there a function to flip a the rows and columns in an excel spreadsheet? In other rows make the rows columns and the columns rows and maintain all formulas?

Link Posted: 7/20/2010 4:56:55 AM EST
Use a pivot table, they are very powerful.
Link Posted: 7/20/2010 4:57:36 AM EST
Copy -> Paste Special ->Transpose
Link Posted: 7/20/2010 4:58:09 AM EST
I believe you can paste special and select the transpose option. But the better option is a pivot table.
Link Posted: 7/20/2010 5:08:00 AM EST
All of the above.
Link Posted: 7/20/2010 5:13:09 AM EST
AutoSum
Link Posted: 7/20/2010 5:27:56 AM EST
=If($a$1="87","FUArock","Pie")
Link Posted: 7/20/2010 5:33:23 AM EST
Thanks all!
Link Posted: 7/20/2010 6:05:47 AM EST
Originally Posted By GumbyTM:
=If($a$1="87","FUArock","Pie")


Link Posted: 7/20/2010 6:08:50 AM EST
Cntl + C ("Copy")
Alt + E, S, e, (a.k.a. "Paste" "Special" "Transpose")
Top Top