Merge tables

[Anonymous]

i want to merge 2 tables and i want the result as described in the photo

kind regards

[TomMartens]

Hey,

from inside the QueryEditor you can use the "Append" function in the "Combine" ribbon of the Home menu.

Hopefully this is what you are looking for.

Regards,

Tom

[Anonymous]

And how can i put them beneath each other.

[Anonymous]

If you want your rows to be sequenced in a specific manner, try adding an index column after appending.

[TomMartens · Accepted solution]

Hey,

the Append transformation actually does what you are looking for except that you will loose the "row headers" of the second table. Maybe this gets you started:

http://radacad.com/append-vs-merge-in-power-bi-and-power-query

If the article does not solve your question, please consider to create a pbix file that contains sample data, upload the file to onedrive or dropbox and share the link.

Regards,

Tom