Transpose cells if not empty in Excel

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I have 34 long groups of numbers in one Excel column. Each group is separated by an empty cell.

Does someone know how to transpose this column to 34 separate rows?

I managed to do it by using the Transpose() function, manually selecting each range between empty cells, and hitting F2 + Ctrl-Alt-Enter, but the list is very long and manually scrolling through it takes forever.

Thank you in advance, irinary

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
hope I have understood what you want

highlight the whole data of 34 rows and sort according to the column which is having blanks in between. the blanks will come to the last if ascending sort.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month