I have a worksheet containing 4,000 rows containing customer names in column
A & product detail in Row B.
I have tried to use V look up but get the same results (John & Carrot)
What I need is when the customer has a different product ie. John & Carrot,
Mary & Apple then John & Apple etc.
Customer (text) Product
John carrot
John carrot
Steve carrot
Mary apple
John apple
John Carrot
Mary Carrot