Forum Discussion
Solved
Power Query - Is it possible to append tables with overlapping data
Hi, I am new to this community and was hoping to get some guidance around tackling an situation I am facing. I receive a data in a table format for last 100days every week. I would like to ap...
After you append one to another, in Power Query editor select both columns
Home -> Remove Rows -> Remove Duplicates
Thanks for pointing that out.
I have updated the data in the tables.
Table 1
| Date | data |
| 1/01/2021 | 11 |
| 2/01/2021 | 86 |
| 3/01/2021 | 20 |
| 4/01/2021 | 39 |
| 5/01/2021 | 21 |
| 6/01/2021 | 35 |
| 7/01/2021 | 94 |
| 8/01/2021 | 23 |
| 9/01/2021 | 47 |
| 10/01/2021 | 70 |
| 11/01/2021 | 97 |
| 12/01/2021 | 15 |
| 13/01/2021 | 77 |
| 14/01/2021 | 58 |
Table 2
| Date | data |
| 7/01/2021 | 94 |
| 8/01/2021 | 23 |
| 9/01/2021 | 47 |
| 10/01/2021 | 70 |
| 11/01/2021 | 97 |
| 12/01/2021 | 15 |
| 13/01/2021 | 77 |
| 14/01/2021 | 58 |
| 15/01/2021 | 10 |
| 16/01/2021 | 43 |
| 17/01/2021 | 41 |
| 18/01/2021 | 71 |
| 19/01/2021 | 96 |
| 20/01/2021 | 57 |
| 21/01/2021 | 20 |
After you append one to another, in Power Query editor select both columns
Home -> Remove Rows -> Remove Duplicates
- Thank you. That worked 🙂
lucioxiii , glad it helped