Transpose cells if not empty in Excel

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