Flipping rows/columns in a sheet

[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

 

[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

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.