Rotate the display of a spreadsheet

[Dave]

I have a SS that is imported from ACCESS that has a lot of field names across
the top, and just a few rows along the side.

Does Excel 2003 have a function or utility or tool that will allow me to
rotate the display so the names are down the side that the data runs aligns
with it?

col1 col2 col3
a b c

would become

col1 a
col2 b
col3 c

 

[KePaHa]

Copy the cells, then do a Paste Special and check the box for 'Transpose'

 

[Ron Coderre]

Try this:

Select the range of imported cells

From the Excel Main Menu:
<edit><copy>

Select the cell that will be the top left cell of the re-organized data.
<edit><paste special>
Check: Transpose....Click [OK]

Does that help?
Post back if you have more questions.

Regards,

Ron
Microsoft MVP - Excel