HI All,
I have the below information in a sheet.
Name Fruits
Peter Fruits Apple
Peter Fruits Pear
Peter Fruits Banana
Sally Fruits Apple
Sally Fruits Pear
I need it to show this way instead
Name Fruits
Peter Apple, Pear, Banana
Sally Apple, Pear
Anyone can advise how can I do that?
Thanks!
I have the below information in a sheet.
Name Fruits
Peter Fruits Apple
Peter Fruits Pear
Peter Fruits Banana
Sally Fruits Apple
Sally Fruits Pear
I need it to show this way instead
Name Fruits
Peter Apple, Pear, Banana
Sally Apple, Pear
Anyone can advise how can I do that?
Thanks!