Duplicate cell values - Grabbing cells 'above' to make a list

Dia dhuit Excel Forum,

I've a similar query to linked I opened 13/4/19: https://www.excelforum.com/excel-for...by-column.html, though this one is more complicated...

Attached file shows taskcards, and for some taskcards, an appropriate check package.

1. A1 - A5 are taskcards without package and are formatted with white fill.
2. A6 has a corresponding package in A7, called 'A03' so it's been filled green.
3. A7 is the package from A6.
4. In columns C-F, the cells show how the taskcards are grouped.
5. A12 is in both A01 & A03 so it's been put into both column D & F.

Is there a quicker method of grouping, other than going through the 850 lines?

Hi Bo_Ry,

This seems to have collected it properly - I'm going to try to break down the formula so I can see how it works, when I do, I'll mark thread as solved.