Hi,

Thanks for checking out my post, I'm after a little help if someone would be so kind. Let me explain my problem. Basically, I have a stock list of approx 25000 listings in a text(tab) file, which I edit in Excel. Duplicate listings appear in different rows. The only thing which is different is the SKU (the SKU refers to the items physical location). Instead of having two identicial listings (minus the SKUs), I require one listing(row) with the two SKUs in it.

I do already have a marco, made by a friend, which flags up duplicates by writing 'duplicate' in column B. This only happens after the first item. Also, the SKU will appear in either the SKU or Description column.

Below is a basic example of how the file currently looks, I have left out some columns which are irrevelant for the time being;

TITLE Duplicate? Sku Price Quantity Description
Blur Parklife Duplicate AA123 4.99 1
Blur Parklife Duplicate 4.99 1 ZZ321
Blur Parklife DJ666 4.99 1


And now below, is ideally how I'd like my listing to appear;
TITLE Duplicate? Sku Price Quantity Description
Blur Parklife Duplicate AA123/DJ666 4.99 3 ZZ321


I'm of OK ability when it comes to basic use of excel, however VBA, marco programming, etc is way above my head, however, I'm pretty sure this can be done.

Unfortunatly I'm on a pretty tight time scale to get this urgently sorted, so if anybody out can help me out, it would be very much appreciated! Also, I'd be happy to buy you a few drinks, courtsey of PayPal, should you help me get this sorted!

Many thanks in advance; Any questions, fire away!

Tom