Need to list ALL values within a given range

So a colleague has a spreadsheet with, what can only be described as a "spattering" of data.

It's 300+ colums wide, and a similar height, containing many blank cells. The data is not uniform in any way.

What we need to do, is get a straight forward list of all of the values. We're not trying to get unique values, or all values within a range, just a list of all ocurrences of all NON blank cells.

I've attached a sheet which I hope will make it clear what we're after....

With the volume of data, we can do this the slow hard way and just move/copy the data around, but I was hoping for a faster/less manual way to do this, but at the same time trying to avoid VBA.

I've tried adding a header row, and using Filters. Then unchecking blanks, and getting the data this way, and that speeds up getting the data for each individual colum, but it still requires going through 300+ colums.

EXAMPLE.xlsx

There is no one-stop-shop, as far as I am aware, but you could select the whole lot and hit F5, then click the Special button and select Blanks. Once you have all the blanks selected, right-click and select Delete - you can choose Shift Cells Up. Now repeat and choose Shift Cells Left. Now you have nothing but populated cells. Is this something that might help?

You're welcome!