Hi Samsson

just wondering why copying your column of data
clicking where you want the row and choosing edit / paste special -
transpose
doesn't work for you?

Cheers
JulieD

"samsson" wrote in message
...
A very useful feature for Excel would be the ability to easily switch a
column of data into a row. This would allow a column of entries to be
used
as a row of headers, for example. Excel already allows switching a column
into a row in the charting area, but not in the spreadsheet. One can work
around this by exporting the column into Word, changing the delimiter
between
fields from a paragraph mark (normally hidden) to a comma, then
re-importing
the data into Excel - which will then be as a row. This would also allow
Access to import the former column into a row, which could then be a list
of
field names.