Dynamically combine tables in power query

[creedrulz]

Hi All ,

I have a need to dynamically append the table displayed in the highlighted screenshot below while ensuring that the highlighted columns are retained. Although I've successfully merged the highlighted ones, I still require the inclusion of the other two columns. Assistance with this matter would be highly appreciated.

Thanks,

Deevs

[lbendlin · Accepted solution]

Power Query does that automatically for you

tbl1 & tbl2   will result in the common columns being used as is, and then uncommon columns slapped on at the end.

[v-huijiey-msft · Accepted solution]

Hi @creedrulz ,

Based on your description of the problem, you want to keep the columns on the left and the right table after the two tables are merged.

Please try:

These are the page effects after the merger of the two tables.

After clicking Expand in the upper right corner, select the field you want to display it.

As can be seen from the figure below, the fields on the left still exist, and the fields you want on the right also exist.

If you have other questions, please contact me at any time.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[lbendlin · Accepted solution]

Power Query does that automatically for you

tbl1 & tbl2   will result in the common columns being used as is, and then uncommon columns slapped on at the end.