Consolidating tables with under date
Hi Guys,
I have a sparsely populated table that consists of a date and then seven category sizes of feed (table 1)
I have a formula for a list without blanks which condense the table. (table 2)
Problem is that i want to dates to line up for each catagory so its easy to read. For example, if there is delivery on the 29/03/20, i want it to search the other size categories to see if there are any other sizes then moved to the next column for the next delivery date. The example of what i want it too look like is in Table 3.
I believe this is quite a complex problem, tried with an IF statement but i cant get it to work inside the array formula. Do i need a macro? i would prefer a formula
Ts difficult to explain in words, have a look at the attached.
I appreciate you guys!!
|