How to group orders and order items?

Hi guys.


Could someone with more experience tell me how to do this or or at least give me the term that I have to research? I don't even know how to google that. I tried concatenate, group tables, merging cells etc but I couldn'd find how do do this.

This is the original table:

ROW Order Name Item
1 11111 John Shampoo
2 11111 John Soap
3 11112 Mary Perfume
4 11113 Eric Printer
5 11113 Eric Headphone


How can I transform this table in order to

if the order number is equal, group the Item colum together ?

The table should be like that.

ROW Order Name Item
1 11111 John Shampoo
Soap
2 11112 Mary Perfume
3 11113 Eric Printer
Headphone

Many many thanks in advance, I've been trying to do this for many hours how.

Leo

I've added a pic, couldn't get the tabs to align properly.