Multiple Orders per Client

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!

Hi All FYI the answer can be found here;

http://www.excelforum.com/excel-gene...n-another.html

Sods law i find it as soon as i post!

Kind Regards,

Chris

See attached file with comments in blue - should be fairly obvious.

Pete