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
b                       5  5
b                             6  6

and I need it to look like this:

a  1  2  2  3  3
b  1  2  2  3  3  4  4  5  5  6  6

I have about 30 columns that need to move to the top value in their group, then removing the duplicates (to which there are about 33 rows of duplicates, trying to get it down to about 8 rows). I have been searching forums for several days and trying bits and pieces of code. I am having such a tough time with VBA!!!!

Same illustration, but graphically:

    →