Sort all cells in range with result which are not blank

Hi all,

I've got the following problem...I've got a rang of cells with multiple columns and rows. Some of these cells have a value in them. How do I sort all of these values below each other?

See the attached sheet for what Í have in mind.

Thanks in advance!

help 2.xlsx

It must be difficult to solve..Also no respons at other forums

can use vba.
or some manual way.
-select your table
-ctrl + g, "special"
-choose "blank"
-right click" delete", "shift cell to left"
-extra column with data just copy and paste to below column A
-remove the blank row again, select whole column, then
-ctrl + g, "special"; choose "blank"; delete row
-choose "sort".

Hope this help