I need a formula to report back cells that meet multiple criteria

I've got a forecast from a customer and need to summarize it with part number, quantity and date.
The spreadsheet is
part no in column a
due dates in row 1
values at the intersection of part no and due date

and

i don't want 0 quantity to report back.

my output needs to be partno, date due, quantity.

thanks for any help.

swwell

here is workbook with before (forecast) and after, the way I want the report.

for the sample, I only filled in to week 38 - obviously there would be more.

thanks

Thank you bebo21999 - this helped much.