Matching Excel cells by column
Hi, I'm trying to do what I thought was a simple match, but it looks to be a little more complicated than I thought. I have two lists, each with their own column & respective ID #. For example, " [Microsoft] [24591245] ", using brackets to indicate cell. I want to match by the cell Microsoft, and I want the ID # to move with the associated cell. For example, I have a problem like this: A B C D Row 1: [Microsoft] [28275721] Row 7: [Microsoft] [9274395] Is it possible to automate putting these two next to each other, using "Microsoft" as the match, and having the ID follow the match? I may want another cell to follow the matching cell as well. I can use condition formatting duplicate values to find the value I want, but sometimes there's duplicate accounts. I would like those to move but if they don't have a matching value that's fine A B C D Row 1: [Microsoft] [28275721] Row 7: [Microsoft] [9274395] Row 60: [Microsoft] [9777772] Would look like A B C D Row 1: [Microsoft] [28275721] [Microsoft] [9274395] Row 2: [Microsoft] [9777772] Is this possible? Or even part of this possible? Thanks in advance