Create new

[samson211]

So as attached in snap, I have 3 columns, I want to create two new column from the exisiting 3.  if Column 1 , Row 1 Data = any of the Column 3 data, then I want go to the corresponding row, and get that rows specific column 1 data into my column 3 of Row 1. Same apply to column 2.

[CoG]

This is a good case for a self join. You just need to be careful about the order of the join to ensure that things come out right. (1 Join Tool + 1 Union Tool per new column). Check out this workflow which achieves the desired result:

Hope this helps and Happy Solving!