I have a two column, eight row table that looks like this:
John apples
John oranges
John bananas
Bob mangos
Bob papayas
Bob pineapple
Jeff berries
Jeff oranges
And I want to transform it to a two column, three row table like this
John apples; oranges; bananas
Bob mangos; papayas; pineapple
Jeff berries; oranges
How do I do this?
Bookmarks