Hi All,

I apologise if this issue has already been tackled however i could not find it anywhere so here goes!

I have an exported Database containing client details and orders, there are many orders per client and therefore the export shows duplicate client records for every individual order.

Preferably i would like to know if there was some way i could turn this:

Client Name Order
Bob Fossil Cakes
Bob Fossil Oranges
Bob Fossil Bananas

To this:

Client Name Order1 Order2 Order3
Bob Fossil Cakes Oranges Bananas

Any help would be greatly appreciated!