combine tow tables in to one

[rasalaprashanth]

Hello All, 

I have 2 tables 

table 1

Cname	Own	rental	r	np	t/f
truck	own	nonrental	0	1	true
truck p	lease	rental	1	1	flase

table 2

Cname	Own	rental	r	np	t/f
bus	own	rental	10	2	true
truck	own	rental	5	0	flase

I need to combine these 2 tables into one, I tried both the merge and the appended.
but I am getting the table side by side not top and bottom.
this is what I am getting when i use merge or append functionality.

Cname	Own	rental	r	np	t/f	Cname	Own	rental	r	np	t/f
truck	own	nonrental	0	1	true	null	null	null	null	null	null
truck p	lease	rental	1	1	flase	null	null	null	null	null	null
null	null	null	null	null	null	bus	own	rental	10	2	true
null	null	null	null	null	null	truck	own	rental	5	0	flase

but instead I need to show the table as

Cname	Own	rental	r	np	t/f
truck	own	nonrental	0	1	true
truck p	lease	rental	1	1	flase
bus	own	rental	10	2	true
truck	own	rental	5	0	flase

[DOLEARY85]

Hi,

append should work in power query, just make sure the column names/data types are the same in both tables:

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