switching rows & collumns

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?

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

Try that out.


"littlewaywelt" wrote:

>
> 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?
>
>
> --
> littlewaywelt
> ------------------------------------------------------------------------
> littlewaywelt's Profile: http://www.excelforum.com/member.php...o&userid=21133
> View this thread: http://www.excelforum.com/showthread...hreadid=490193
>
>