Hi,
I have 2 columns of data that look like this

CH301 9087
CH301 9021
CH412 9594
CH412 4897

I need them to look like this

CH301 9087 9021
CH412 9594 4897

The number in column "A" can from single to multiple
There are 1,628 rows incl header

Could anybody suggest a good way to do this?

Thanks