Rows to one Column including empty cell as well

[waqar1239]

Hi All,

I appriceate if someone can send a macro which can convert all of my rows into one column including empty cells.
I have a data of rows 3798 and columns 26 and which i want to convert all my rows 3798 into one column.
Please advise me.

cheers

 

[alansidman]

Load your data into Power Query/Get and Transform on the Data Tab. Unpivot your data. Close and Load will put it back into an excel spreadsheet.