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