VBA Code to reformat extract

[sx200n]

Hello,

I need some assistance please. I have posted this on the Formula forum a few days ago and I did get a response which was helpful, but my requirements for this extract have now changed and I need to look for VBA coding to automate.

Basically I have a messy extract that lists vertically a column of unique client ID numbers (unique in that they are always for that customer but not unique as they appear multiple times) with a second column telling me a product code that they have purchased. The issue being is that each client could appear just once, but could also appear anything up to 4 or 5 times which is where the issue is.

I need VBA to format this extract so that the client ID number only appears once in the column, but if there was more than one occurance in the original extract, the product codes need to appear horizontally so that I can do a VLOOKUP against the final result.

Unfortuantely, whilst I am handy at times with formulas and VBA - this particular problem is beyond my capabilities.

I have attached a very basic example spreadsheet to demonstrate what the extract looks like currently and how I need it to look. It is far easier to show you than explain.

Any help would be really appreciated.

Kind Regards

[jindon]

Try

Please Login or Register  to view this content.

[sx200n]

Jindon,

Your a star. Thanks. Does exactly what I need.

[jindon]

You are welcome and thanks for the rep.