How to group a cell from multiple rows into a single cell in one row? (screen shot included, hard to explain in words)

[leoleo]

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.

I have the data as the first table and they need to be as the second table (order items in one cell, one row per order).

Don't need to go in details, just a general overview is already very helpful.


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

Leo

 

[Sandeep Warrier]

Hi & welcome to the Board!

It'll be helpful if you could provide sample data.

See my signature for a few methods on posting sample data.

 

[leoleo]