lookup dates and gather same dates items

[proficient]

Hi All, I am working on a sheet, there is a unique ID for all items mentioned in headers that are more than 30 (but I have mentioned some of them as example) and their status below them i.e dates (ETA) or IN-HOUSED (means item received). What I want you guys to do is that if items for a particular ID will arrive on same date like hang tag, poly bag, and jackron (belong to ID 1212) are arriving on 8-Oct and rivets and clips for same ID on 10-Oct so the formula or VBA code will show the outcome in cell I1 same as I manually put in I1. Hope it clears. see below chart for your ease. thanks in advance.

A1	B1	C1	D1	E1	F1	G1	H1	I1
ID	HANG TAG	CARTON	POLYBAG	JACKRON	BUTTTON	RIVETS	CLIP	RESULT
1212	8-Oct	INHOUSED	8-Oct	8-Oct	INHOUSED	10-Oct	10-Oct	HANG TAG, POLYBAG, JACKRON 8-OCT, RIVETS, LIP 10-OCT
1526	13-Oct	13-Oct	13-Oct	INHOUSED	10-Oct	9-Oct	INHOUSED	RIVET 9-OCT, BUTTTON 10-OCT, HANG TAG, CARTON, POLYBAG 13-OCT
1684	INHOUSED	9-Oct	8-Oct	INHOUSED	INHOUSED	10-Oct	INHOUSED	POLYBAG, 8-OCT, CARTON 9-OCT, RIVETS 10-OCT

<tbody>
</tbody>

 

[proficient]

Help!