How to combine tables with different columns in excel

Perfection

not having that button....

Thanks a lot. What f the table that I want append contains some rows that are similar in the first column to the initial table but with more data in two other columns that also exist in the initial table ?

First you eat well and speak loud☺

Thank you! Does this work if you do not first create the connections? For example, if you just went straight to the Query Editor and "Appended 3 or more sheets"? I'm not understanding the purpose of creating the Connections in the first step.

Hi! Thanks for showing us how to do this. It helps a lot. My only concern with this is that I have more than 10 files that I need to convert to tables. Is there a way other than opening each file and converting the sheets into tables to make sure the headings align?

almost impossible to hear this video..

Great thanks very much. Pretty much wasted an entire afternoon trying to follow half hour long Power Query videos and then you explained it perfectly in 4 mins. Are you single?

Love you. I would propose to you if I were handsome

Bossed it. Thanks Karina, this saved time that would have been spent writing up VBA code. Really clear and a great example of what Power Query can do.

awesome! thank u so much!

Thank you, is there a way to combine two tables, but they have different columns. they have a primary key.
I need to create a connection with the primary key between the two tables, then combine the two tables together without using a pivot table

Thanks for this. Wonderful video that has saved us countless hours putting 20+ sheets with varying (but similar) numbers of unique and shared columns. Worked like a charm.

USE A LIGHT SHEET TO EXPLAIN

I have 2 excel sheet, one having student name, class & roll num and another sheet having student name & class. Now in sheet 2 we want a formula, if student name & class is matched, who auto pick student roll num. Pls advice.

i could not find get & transform option in my excel 2010. please help