Collapse empty cells, move data up

[Nebs]

See attached file.

What I'm trying to do is shift all the data for each column to the top 5 rows (in the same order they're shown in) and ignore the empty cells in-between. How can this be done (preferably without the use of VBA which I struggle with)?Example.xlsx

Thanks

[windknife]

According to your data, you can use formula as follows:

B6

Please Login or Register  to view this content.

See Attached.

HTH,
Windknife

[Nebs]

That's amazing, thank you so much!!