AWESOME Excel trick to combine data from files with DIFFERENT headers

I want to combine data from different files, but the format doesn't match. In this video, let me show you two advanced Excel tricks to solve the problem.

We are going to use Power Query and simple M code to take data in different files and combine it. This works great if you have files with columns out of order or different column headers.

⏱ IN THIS VIDEO:
===============
0:00 - Problem 1: Columns not in same order
4:08 - Problem 2: Column names do not match!

📂DOWNLOAD SAMPLE DATA:
=========================

Use the instructions in the video to combine the data.

👩‍💻 MORE POWER QUERY:
======================

👩‍💻👩‍💻 EVEN MORE ON POWER QUERY:
================================

If you want to learn even more and see how Power Query can be integrated with other Excel features to make your life simple, join my Excel School program. In this complete course, you will learn how to use Excel & advanced Excel for data analytics job.

~

#Excel #combinedata

[alfredoluwatomi]

Waoooo, this is awesome.I have been looking for something like this but all the videos I watched are just too way complex to understand.
Thanks so much Chandoo for this simple straight forward approach, you are such a fantastic guy in excel.
More power to your elbow.

[BenDieselBasicAutomotive]

Very complicated topic yet... explained in simplified way.... I was able to get it.... even if am just an average person and has no formal @ educational training in programming... I applied most of your excel techniques in my office work. My Boss was impressed with my presentation... Thank you very

[yufanli]

this is exactly what I am looking for ! Thank you so much !

[abhishekupadhyay]

Every time I watch your video I learn something new. Keep it up.

[johnborg]

Thanks Chandoo !!! This is a very common problem to many!! Thanks again!! :) :)

[bigt]

Exactly what I want to learn! Thank You!!!

[niggszo]

Chandoo is "Awesome".. Thanks man!

[janinemccown]

love this video and great information I can use right away

[arbazahmad]

Excellent and easy to understand👌.
Thanks you Chandoo for this Mcode..

[karimallahwala]

Thank very much for sharing that great knowledge

[BenDieselBasicAutomotive]

new learning for the day!.... Thanks again, Sir.... I'm an avid fan...

[FirestormT]

As always awesome :) Thank you Chandoo

[BOOBOY]

Hi Chandoo i'm one of your sons friends Nish. and I was in nakshu's class last year, you have great content and tutorials!

[successmantra]

It awesome, today I was looking for this topic and i got yours as notification. Im happy in learning this.

I would like to get one more video on the same topic. Where we have multiple workbook with multiple sheets but all work book has same format and even the sheet name. How to consolidate the workbook as per sheets.

[teoxengineer]

Chandoo, it is so so good tutorial. I have sometimes trouble for this issue and I couln't solve it and it makes my brain confuse.
Are there any more examples to combine different methods?

[calbiju]

Hi Chandoo, it is a wonderful video. Am trying to combine files with multiple sheets with different names and different column names. It’s way too complicated.

[vv]

nice, but how to approach when only one of the multiple files have headers, rest have data in same column order, but dont have headers..!!!

[sadiaehsan]

Please make video on Small, ROW Combined in excel ...for filtering data