Flipping rows/columns in a sheet

J

jmcaddell

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel

I have a spreadsheet where I would prefer the rows to be columns and the columns to be rows. This would help me extract data using a comma-delimited format.

Is this possible to do in Excel?

Thanks, John
 
B

Bob Greenblatt

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel

I have a spreadsheet where I would prefer the rows to be columns and the
columns to be rows. This would help me extract data using a comma-delimited
format.

Is this possible to do in Excel?

Thanks, John
Click to expand...
Yes. Copy the area. Switch to a new worksheet (or some other place on this
worksheet) Select the starting cell, and then Edit-paste special and chose
transpose.
 
Top