(This is an updated version of this question - I am trying my best to make myself clearer this time.)
I am trying to use a query to copy values from one column to another.
Both source and destination columns have a name on their left columns, and the name must match. The source names could be duplicated, and in that case, I would like to have the entry on the bottom. There could be empty rows as well.
If a name in the source is not found in the destination, then don't copy it.
If a name in the destination is not found in the source, then leave the destination value blank.