My friend has two columns where one has unique values and another column has those same values but also duplicated like shown below
Column 1 Column 2 ABC123 ABC123 CDE456 ABC123 EFG789 ABC123 ABC123 CDE456 CDE456 CDE456 EFG789
Sometimes column 2 doesn't always have all the values in which case i think it just needs to be clear that they do not exist in columm 2. What he wants to do is he wants the values in column 1 to shift to the row number of the same value in the duplicate values column like shown below.
Column 1 Column 2 ABC123 ABC123 ABC123 ABC123 ABC123 CDE456 CDE456 CDE456 CDE456 EFG789 EFG789
Is there a way to do this in excel painlessly with either a macro or an inner excel feature?