using if/then and using sorting to parse data and create list without spaces

Try this...

Enter this formula in cell A1 and copy across to B1:

=IFERROR(VLOOKUP("y",$E12:$G19,COLUMNS($A1:A1)+1,0),"")

Format cell B1 as Date

Enter these column headers:

C1 = Product
D1 = Qty

Enter this array formula** in C2:

=IFERROR(INDEX(H$11:U$11,SMALL(IF(INDEX(H$12:U$19,MATCH(A$1,F$12:F$19,0),0)<>"",COLUMN(H12:U19)),ROWS(D$2:D2))-MIN(COLUMN(H12:U19))+1),"")

Enter this array formula** in D2:

=IFERROR(INDEX(H$12:U$19,MATCH(A$1,F$12:F$19,0),SMALL(IF(INDEX(H$12:U$19,MATCH(A$1,F$12:F$19,0),0)<>"",COLUMN(H12:U19)),ROWS(D$2:D2))-MIN(COLUMN(H12:U19))+1),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Select C2:D2 and copy down to a number of rows that is equal to the number of products you have. In your sample file there are 14 products so you'd need to copy the formulas to a total of 14 rows.

Here's you file with these formulas implemented.

sample list(1).xlsx