VBA code to list all products from each customer in one note

I am new to VBA programming, I need a VBA code which list all products purchase (Column I) by each customer(columnn G) in one row. It should add list name only once if there are multiple products purchased by same customer. For example output note should be like

Claire Gute - FUR-BO-10001798
FUR-CH-10000454


I have a similar problem but can't share the sheet due to access issues outside work. Sample excel sheet attached.