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]  ", 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] 
Row 7: [Microsoft] 
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