ExcelBanter - Convert columns to Rows

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Convert columns to Rows (https://www.excelbanter.com/excel-programming/376665-convert-columns-rows.html)

JOM

Convert columns to Rows

I have at least 255 columns and I wanted to convert those columns to rows...
How do I do that?

Caroline

Convert columns to Rows

Copy values in column, then paste special/transpose
--
caroline

"JOM" wrote:

I have at least 255 columns and I wanted to convert those columns to rows...
How do I do that?

JOM

Convert columns to Rows

Thank you so much that was easy....

"caroline" wrote:

Copy values in column, then paste special/transpose
--
caroline

"JOM" wrote:

I have at least 255 columns and I wanted to convert those columns to rows...
How do I do that?

All times are GMT +1. The time now is 05:37 PM.