So frustrating! I get data sent to me and it looks like this:

a 1

a --2 2

a-------3 3

b 1

b-- 2 2

b ------ 3 3

b------------ 4 4

and i need it to look like this:

a 1 2 2 3 3

b 1 2 2 3 3 4 4

I have about 30 columns that needs to move to the top value in their group, then removing the duplicates. I have been searching forums for several days and trying bits and pieces of code. I am having such a tough time with VBA!!!!