INDEX of all numbers in a range, no white space

[The Phil]

I am trying to make a list of numbers from data range Data!$B$8:$AF$29 but I want it to ignore the white space. I've tried a few formulas using INDEX but it doesn't work. Maybe there is another formula that would work for me?

I attached a simple sample.

[DonkeyOte]

Questions

1 - Do they need to be listed in the order in which they are found or can they be listed any which way ?
(if they do need to be listed in order - what is the order - row then column ?)

2 - Are you open to doing this with VBA ?

Question 2 is relevant if answer to Q1 is Yes... (formulae will be relatively expensive)

If answer to Q1 is No then one way would be to use SMALL, eg:

B1: =COUNT(Data!$B$8:$AF$29)
B2: =IF(ROWS(B$2:B2)>$B$1,"",SMALL(Data!$B$8:$AF$29,ROWS(B$2:B2)))
copied down as far as required

[DonkeyOte]

I'm heading off but on the off chance you do need the list in order outlined then I would suggest you use some helpers to return index positions eg.... (using B1 as before)

A2:
=IF(ROWS(A$2:A2)>$B$1,"",SMALL(IF(ISNUMBER(Data!$B$8:$AF$29),(COLUMN(Data!$B$8:$AF$8)-COLUMN(Data!$B$8)+1)+(ROW(Data!$E$8:$E$29)-ROW(Data!$E$8)+1)/100),ROWS(A$2:A2)))
confirmed with CTRL + SHIFT + ENTER
copied down as required

B2:
=IF($A2="","",INDEX(Data!$B$8:$AF$29,MOD($A2,1)*100,INT($A2)))
copied down per A

[The Phil]

B1: =COUNT(Data!$B$8:$AF$29)
B2: =IF(ROWS(B$2:B2)>$B$1,"",SMALL(Data!$B$8:$AF$29,ROWS(B$2:B2)))
copied down as far as required

This is all I need, Thank you!!!