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.

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.

Maybe he never heard of "Transpose"?<g
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

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