View Single Post
 
Old 06-18-2020, 12:26 AM
Danny cool Danny cool is offline Windows 10 Office 2013
Novice
 
Join Date: Jun 2020
Posts: 5
Danny cool is on a distinguished road
Smile 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!!
Attached Files
File Type: xlsx Table sort.xlsx (257.1 KB, 8 views)
Reply With Quote