How to combine Tables using the M Language Function Table.Combine in Power Query

What if we combine multiple tables that only have some column headers in common into just one table?

This video shows one way of doing that in Power Query in Excel.



----------------------

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer

________________________________________________________

Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
___________________________________________________________________



Twitter: @celia_excel

Instagram: @solveandexcel


#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA

#microsoft365 #microsoft #toronto #torontobusiness #wit #microsoftexcel #excelreport #excelautomation #snapreports #powerquery #powerquerytraining #powerqueryeditor #worksmarternotharder #canada #msexceltraining #microsoftexceltips

[jazzista]

2 great tricks again Celia: The Table.Combine function AND avoiding spaces in the step names to avoid the annoying "# " symbols. Thank you again. Will work on those 2 tricks at work.

[rodrigogodoy]

Muito Obrigado Célia. Sensacional. Simples, direto, fácil.


Abs do Brasil

[martyc]

Great vid Celia - I really like your short 3/4 minute videos lately. Not sure if it’s intentional or not but I think it’s a great length for people to quickly digest.

[floresj]

can you make the product consolidate so that there is not any null values from the other tables? Is it possible to consolidate the information so that the Basic, premium, diamond are on the same row in its needed column?

[thebhaskarjoshi]

What if we also want to merge the values from the [Name] column with their corresponding tables?

[brincandenegocios]

great... but what happens it the tables have different columns as well?

[caiquebeck]

Hi Celia, thanks for your tips!
About the question in coments below: "What happened to the first column [Name] (ie: Toronto, ...) ? Can't we keep it available after the Table.Combine executes ?".
have you ever solve it? The answer doesn't show to me.
Well, I subscribed in your channel and I'm looking for the solution there.
Thank you for your nice pills of knowledge!

[CarlosEduardoKoshevnikoff]

Hi Célia, great example though I have a diferent task in my case.
I wish to Merge queries from two tables wish we have a duplicate rows in both arquives and cannot be duplicate in the new Query.
How can I get those info into in one Query without duplicate rows?

[nicor]

What happened to the first column [Name] (ie: Toronto, ...) ? Can't we keep it available after the Table.Combine executes ?