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