Rotate the display of a spreadsheet
 

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

Rotate the display of a spreadsheet
 

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

"Dave" wrote:

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

Rotate the display of a spreadsheet
 

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

"Dave" wrote in message
...
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