Automatically delete empty rows in new column

[gieleke6]

I have a column in Excel with a number of values below each other, with empty rows in between. I would like to automatically create a new column on a new page where all these values will be lined up, without the empty rows in between.
Is there a way (formula) to do this?
To illustrate, I have attached a file of how I would like it.

Hope you have an idea to make this happen!

Thank you in advance
Giel

[azumi]

Put in D5 then copied down

=IFERROR(INDEX($B$5:$B$15,AGGREGATE(15,6,(ROW($B$5:$B$15)-MIN(ROW($B$5:$B$15))+1)/($B$5:$B$15<>""),ROW(A1))),"")

[Gregb11]

"mac" is not an Excel Version - please update your profile. IF you are on MS 365 or 2021 or higher, try this:

=FILTER(B5:B15,B5:B15<>"")