Hi, does anyone have some code that could do the following? Column A is Invoice, column B is Serial:

BEFORE

INVOICE
 SERIAL
1000 ABC1
ABC2
ABC3
2000 ABC4
3000 ABC5
ABC6

AFTER

INVOICE
 SERIAL
1000 ABC1,ABC2,ABC3
2000 ABC4
3000 ABC5,ABC6

In short, group all serial numbers for an invoice on one line in column B beside the invoice, comma separated.

In the right hands this would be easy, in mine impossible!

Many thanks in advance.

Baz