How to connect two tables in Excel - With Example Workbook

How much I learned from you , more than a mere word of saying thank you!!!

Batman clip was so inteligently chosen, it fits so well it made me chuckle. Brilliant stuff Chandoo.

Great tips!! Thank You!

Is the power query method still working now. I followed your steps but it doesn't seem to be working for me. In your document, when combining the sales table and people table, the 2 tables only had the first column as a match but when I do the same with my document it doesn't want to merge because the 2nd column in my 1st table is not there on the 2nd table. 1st columns do match. I'm using office 365

i usually just choose close and load to onto a new worksheet? may i ask what is the different from you making a connecction only and then extending the result table onto a new worksheet?

Is it possible to shuffle one column so it matches the first with the corresponding data. Leaving rows which do not align blank.

Hi CHandoo, after you merged the tables in Power Query, and then "load to" and create connection only, I noticed that you didnt select "add to data model", would you need to add to the data model only if you want to use power pivot and create pivot tables from the new merged data?

CHANDOO THE GREAT !!!

Thank you

Excellent teacher!

You my friend are awesome! Thanks for teaching

What if we have multiple excel files

Hi Chandoo I have a question. We have an excel sheet that contains several tables. Each table represents a day of the month, and the content of all the tables is the same. Is there a way to combine all the tables to one?

I wasted 3 hours just to understand Xlookup formula 😂
Finally I got a video

Thank you very much all your videos are useful and helpful

But I don't want a new merged table. In my instance, I need Power Query to add the looked up data to the original column.

Great video!
Can this be done in Power BI?

How can we check the differences in two Excel sheets? And how can we find the duplicate data in excel?

Thank you for this video, the power query part was something I had been looking for, for months. Keep doing you, big love.

Hi Chandoo. I have about 62 excel files from 6 health facilities. There is a column that contains patient ID. The problem is that content of this column ranges from numeric to alpha-numeric. When I load the file in power query, it converts numbers like "00002345" to 2345 which defeats my intention. Kindly help.

Hi, Need your help on powerquery, as i have two power querry excel sheet, can i vlookup it from each other

Hi Chandoo, my name is Harvinder. I have been following you recently and am impressed with the way you teach excel in your videos. I need you help on something.

I have a master file and few other files like qualit, attendance and compliance. I want to know how to formulate the sheets so that the master file gets updates when I update any data on the other files.

Hope u read my message and reply.

Thank you

Sorry for my ignorance but does it merge/ignore duplicates, eg i worked on a few policy no's yday and have updated the status as completed, pending etc, when i pull a fresh report today and merge it with ydays report it should only show 1 entry of the policy no. that is still pending and not 2 entries. Hope i made sense, any help wud be much appreciated

why did you write people? there is no people table

The use of that Dark Knight Scene gave me goose bumps :D Love the creativity!

YES THATS THE STYLE I WANT OMG

❤️❤️❤️❤️

Just only one word for you - Fantastic 🥂

Where to get this data

Thank you Chandoo! Very helpful tips as usual! 🙂

Realy greta...tool to learn

In an ideal world I'd use SQL or Python or Power Query in that order. But I'm guessing in the real world formulas would be your available option, and with a little copy and pasting it's actually less tedious than I imagined. Great video as usual.

Thank You ❤️

Simple but required many times

Nice, can you make advanced video for powerQuery?

Thank you So much Sir....🙏🙏.. Power Query really So Powerful.. I liked your DAX video also.. in this video teached how to combine two table...😊

I literally have a project that I have to combing multiple tables TODAY and generate a report tomorrow by COB. Bless you sir 🙏 🙌

Learn PQ, PP, PBI, Python and SQL. Yes, long learning curve, however, job guaranteed!

You are such a good teacher 🙏 Thank you very much

Thank you sir 🙏

Awesome trick to combine. Thanks sir

Create streamlit dashboards / PowerBI dashboards videos more

In case the tables have columns calculated with formulas. Is it possible with Power Query to keep the formulas while combining?

Awesome video as always.

PQ is the future.

Super helpful, thanks Chandoo!

👏👏

Your videos always help me a lot 👏

Hi Chandoo, as always super. But what if the data is on different workbooks ? Is there a way to merge them using power query merge option without bringing them into the same workbook on different sheets ? Cheers Prem

Just what I needed to learn