Hie, can anyone help with the following:
COL A COL B COL C COL D
Unit 1 Unit 1 3B Unit 1: 3B, 5LH, 6RH
Unit 2 Unit 1 5LH Unit 2: 4B, 6LH, 7RH
Unit 3 Unit 1 6RH Unit 3: 5B, 4LH, 9RH
Unit 4 Unit 2 4B Unit 4
Unit 2 6LH
Unit 2 7RH
Unit 3 5B
Unit 3 4LH
Unit 3 9RH
Unit 4

What i've got are 4 unique units, each of which have a handing assigned to
them.
I need to concatenate the info in each column against each unique unit,
which gives the info on one row for each unit (COL D).
This is just an example. I may have unique units which have no handing info
against them (e.g. Unit 4) and therefore will appear on there own in COL D
with no handing info against them etc.

A macro to automate this process would be greatly appreciated.
Thanks
--
jj