String Concatenation of same field. (1 Viewer)

[rsmonkey]

Hello all,

rite baisically i've imported an excel spreadsheet and it contains a list of purchase orders, however where their is multiple items for a purchase it splits the order up into multiple items on the spreadsheet.

For Example:

Order Number         Product
1                         Cheese
1                         Crackers
2                         Apple
3                         Pears
4                         Rice
4                         Chicken
4                         Curry Sauce

Rite sorry for those hungry people out there!

Baisically pretty obvious what i want.

Order Number:         Product:
1                         Cheese, Crackers
2                         Apple
3                         Pears
4                         Rice, Chicken, Curry Sauce

So i need to know how to concatenate the same field where the order numbers equal each other!

I realise this is gunna have to be a VBA loop but thats pretty much as far as i've got! Rubbish i know but its friday morning and i cant get my brain in gear!

Any help is much appreciated...

 

[Uncle Gizmo]

There is a thread here that will hopefully provide you with some useful information.