Convert array (with multiple blank cells) into a single column (without blanks)

Hi,

I have an array with many blank cells. I would like to organise the non-empty cells into a single column, in the correct order. To make things more complicated, the 'blank' cells aren't actually blank, but formulas that return an empty string (i.e. "").
I've attached an example sheet.

I've racked my brain trying to figure a way using OFFSET but I can't figure it out.

Any help would be much appreciated,
Thanks.

=iferror(indirect(text(aggregate(15,6,(row($b$2:$m$11)*10000+column($b$2:$m$11))/($b$2:$m$11<>""),o2),"r0000c0000"),),"")

Originally Posted by tim201110

=iferror(indirect(text(aggregate(15,6,(row($b$2:$m$11)*10000+column($b$2:$m$11))/($b$2:$m$11<>""),o2),"r0000c0000"),),"")

You sir, are a legend
Thank you so much!