Sort/Merge rows
Hi,
Can someone give me some ideas on how to Sort and Merge data with a
macro to accomplish the following?:
Before Sort/Merge
A1 123
A5 456
A3 789
A1 222
A5 333
A5 111
A3 655
I want to sort the data by the first column and then merge the data so
that I have unique values in the first column. I would expect the
result of the sort/merge to be:
After Sort/Merge
A1 123 222
A3 655 789
A5 333 456 111
Thanks
|