Excel 2010 Move data from multiple columns to single row
- by frustrated529
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!!!!