Forum Discussion
Merge tables
i want to merge 2 tables and i want the result as described in the photo kind regards
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
And how can i put them beneath each other.
If you want your rows to be sequenced in a specific manner, try adding an index column after appending.