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:
=========================

Sample data - https://chandoo.org/wp/wp-content/uploads/2023/02/different-files-formats.zip
Use the instructions in the video to combine the data.

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

[100k+ views] Quick basics - https://youtu.be/UAFExySaSPY
[400k+ views] Deep dive - https://youtu.be/PiFAa_jjaEI
[200k+ views] Combine files in a folder with Power Query - https://youtu.be/SGzegma9bdY
[500k+ views] Combine all sheets in one file with Power Query - https://youtu.be/k_ugshJ4wIw

⏯ POWER QUERY PLAYLIST - https://www.youtube.com/watch?v=PiFAa_jjaEI&list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2

👩‍💻👩‍💻 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.

Visit https://chandoo.org/wp/excel-school-program/ to sign up.

~

#Excel #combinedata

Видео AWESOME Excel trick to combine data from files with DIFFERENT headers канала Chandoo