ExcelBanter - How do I take information in 1 column to make column headings?

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

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

- - How do I take information in 1 column to make column headings? (https://www.excelbanter.com/excel-discussion-misc-queries/60828-how-do-i-take-information-1-column-make-column-headings.html)

Northside

How do I take information in 1 column to make column headings?

I have information in 1 column that I would like to rotate and make column
headings. Is there an easy way to do this besides cutting and pasting cells?

Niek Otten

How do I take information in 1 column to make column headings?

Copy and Paste Special, check Transpose

--
Kind regards,

Niek Otten

"Northside" wrote in message
...
I have information in 1 column that I would like to rotate and make column
headings. Is there an easy way to do this besides cutting and pasting
cells?

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