Forum Discussion
Copy data to other columns
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
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
Solution Sage
Solution SageIn 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.