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.