Power Querry: extend the rows of one table with the content of rows of a nother table

[Pete230]

Hi guys,

I have 2 tables, table A hast 5 columns, table B 3 columns.

What I would like to do is to add the rows of table B into Table A; so that I can use one column to distinguish the varios kategories of my data within one column.

Anyone an idea how to achive that?

Best reagards,

Pete

[Pete230]

Works perfectly fine, my issue was, that the titels of the colums havent been exactly the same, that's why they have been writen beside the other columns not underneth.

But thank you, it workds now!

[Idrissshatila · Accepted solution]

Hello @Pete230 ,

You can use append queries, check this for instructions https://learn.microsoft.com/en-us/power-query/append-queries

If I answered your question, please mark my post as solution, Appreciate your Kudos  👍

Follow me on Linkedin