Merge Multiple Records for Single Client

[LilacDaffodil]

I have 1500+ records, with the data pulled in from 4 tables. This means that some of the clients have more than 1 record, although the product is different in each record, so I need to be able to merge all the data for each client into a single record. In addition, I would need to set the Status of the new record to 'Multiple Products'. Is there any way of doing this please? Many thanks.

[miTutorials]

Try following the below tutorial as a starting point.

Combine / Merge Rows based on ID column using power Query in Power BI | MiTutorials - YouTube

[LilacDaffodil]

Apologies - example file can be downloaded here. 

I have highlighted the merged records in red.

Thank you 😁

[serpiva64]

Please make an example with sample data and the desired result