switching rows & collumns

L

littlewaywelt

I have an excel file that I have imported from an access database.
I am wondering if I can reverse the rows and collumns.
I have 215 rows (5 are headsers), but 257 collumns (excels max). If I
can reverse the two I'd be able to combine two spreadsheets into one.
Any way to do this?
 
P

Peter Ellis

Select the cells you want to switch
Edit menu | Copy
Edit menu | Paste Special
Use the transpose option.

Try that out.
 
Top