PERFECT - thanks

"Peo Sjoblom" wrote:

Copy and paste special and select transpose, test on a test sheet first

--
Regards,

Peo Sjoblom


"Jenny" wrote in message
...
I have a row of data - for example column headers - that I'd like to
convert
to one column of data. Any ideas?