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