Need to list ALL values within a given range

[Darth269]

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