Build a consolidation list from array

Hi all,

Here I have another question. How to pull values from an array to the consolidation list excluding blanks. Bear in mmind there are two criteria - product and date.

See the attached dummy.

Thanks.