Hello,
I have a dataset of over 50k records.
I need to combine the multiple records on 2 columns with a semi colon delimiter.
I tried merge/group by using PoweQuery but the group by will only show those columns I choose.
I need to have all the columns displayed.
The unique id would be based on the QueID and CustomerID and the delimiters would be on the Color and Year columns.
Not sure if i explained this good enough, I have attached an example file.
Thank you
Bookmarks