Make a List from a table

I need to make a list order by numbers from a table.

You can see detail and explanation in attached file.

Thanks in advance for any reply and help. Looking for a formula solution, no a macro.

Regards,
turist

With helper column (say E)
in E1:
=MIN(Sheet1!A:A)
in E2:
=IF(B1="",A2,E1)
in B2:
=IFERROR(SMALL(OFFSET(Sheet1!$B$1:$AZ$1,MATCH(E2,Sheet1!$A$2:$A$26,0),0),COUNTIF(E$2:E2,E2)),"")
and in A2:
=IF(AND(B1<>"",A1<>A$1),"",IFERROR(SMALL(Sheet1!A:A,COUNT(A$1:A1)+1),""))
select row 2 (A2:E2) and copy down