ExcelBanter - Move data from row to column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Move data from row to column (https://www.excelbanter.com/excel-discussion-misc-queries/21788-move-data-row-column.html)

Jenny

Move data from row to column

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

º¼ÖÝÈË

TRANSPOSE()

Peo Sjoblom

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?

Jenny

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?

All times are GMT +1. The time now is 08:43 AM.