Hi! My problem is the following:

Column A consists of hundreds of 8-digit numbers (ie "12345678"). Many of these are duplicates. But the "Remove Duplicates" command is not quite what I need because for the duplicate 8-digit numbers in Column A, there is information in Column B, and Column C that I want to keep (when I use the "Remove Duplicates" command now, I haven't quite found a way to have the information from Columns B and C move to its corresponding 8-digit number from Column A. Instead, the duplicates from Column A get deleted-- leaving an empty space where they duplicates used to reside in Column A, but the information in Columns B and C in the same row (now without anything in their Column A cell)).
ex:
Column A Column B
12345678
22345678
32345678
42345678
52345678
62345678
12345678 XYZ123
12345678 GRT4


From this example, the output that I would hope to get is:

Column A Column B
12345678 XYZ123 | GRT4
22345678
32345678
42345678
52345678
662345678

I would greatly appreciate any help or advice that you can provide.

Thanks,

Ben