Copy data to other columns

[awawaw]

Hello everyone,

I have a question, please help me with this. 

How can I copy the data in Table2. to corresponding column like the screenshot belowing. 

Thank you

[bolfri]

I think is what you did is merge queries and you suppose to use append queries.

Refference: https://www.youtube.com/watch?v=oUB11A855g8

[awawaw]

Hi @bolfri 

Thanks for replying me.

I do need to merge queries, buecause I need to follow some logics to remove or add data so I choose to merge them. I need to know which table it's coming from.

[bolfri]

Can you provide some sample data to work with and the logic you want to apply?

On your example you have same columns and business meaning that's why I said it would be better to append them. Even with appending data you can save an information about the source table name.

[awawaw]

The logics are simple. Only 2 rules.

1. if name shows in table1 but not table 2 then remove it from table 1.

2. if name shows in table 2 but not in table 1 then add it into table 1.  

All the data fields are same for both table. 

My idea is merge them together and expand the table. Adda new column to check I want to remove or add or keep. So I got the table you saw.

[bolfri]

In this case it's still better to do the append with filltering out the records from table 1/2 (putting your logic) than creating custom column that combines them together. It's more manual work. To avoid manual work you can use Power Query M to do that for you.