It's seem impossible for me to do with merge cell across days with formula, and seem your requirement need VBA to archive.
But if you don't mind to NOT use merged cell across days, please review in this file.
I need a helper sheet to collect data first and locate for each row of matching criteria.
By counting & locating
B4 in CountD (Helper sheet) for count how many match for each day.
D4 in CountD for index the item.
and K4 for grouping together
Then in Outcome
B9
You will see many of #N/A , that's mean there are no date is list in CountD (helper sheet)
just add more rows until it's enought.
Regards.
Bookmarks