Merge of data and grouping required retaining original result of merged data

[troywhite1111]

Hi All.

Either with a formula or Power Query.

How do I merge COL D together with a comma separating each value and grouping it by COL A

I also want to keep COL F unique and display in the new table which shows the result for each record in COL D

Thanks