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
|