Combine Data from Multiple Excel Files in a Single Excel Sheet - Part 2

In this video you'll learn to Combine data from multiple excel files into a single Excel Sheet using Power Query. In this case I am assuming that your data structure will NOT be the same

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog - - - -

[kostiantynmakeiev]

after spendin I do not know how many hours of reading and watching some videos, in despair I opened that one - and this was brilliant, very easy to understand and to apply for my issue! Thank you so much!

[jitendrakulkarni]

Very simple English, nicely presented

[amirsaiftaz]

I was searching for merging multiple sheets into one sheet, thanks for your both videos helping me a lot to understand power query function. Amir Saif

[dgkm]

Thank you very much, this video is exactly what I needed to properly understand what I've been doing wrong. Thanks!

[navneettiwana]

Pretty much useful and well explained👍

[mohdmuzammil]

Explained very well.
What if there is spelling mistakes sales rep name in two different years your response will be highly appreciated

[sureshable]

Explanation is fantastic.
Content is superb.
Thanks a lot.

[sumanjalir]

Hi Sir, is there any formula or format to prepare One View Dashboard Xl without sharing any reference data to others like just enter the one word or one number(which are mentioned in reference files) at any cell then it Comes all the required data at a time .. Please reply for this query it's Very useful to my profession

[SHIVAPRASAD-ovjy]

Thank you for the Video, it is really helpful. Have a question, what is the option if I want to filter based on Sales person in combined file

[nallelialvarado]

Thank you for your video! I have a question. Is there a way to add a row with a name of the file? For example, say I'm getting the data that you're using but it does not have the row with the dates, just the data. The date is only in the title of the file. How can I add a name automatically that matches the name of the file?

[philren]

Very useful and effective for my daily work, thanks.

[judyrodbryanvicente]

Hi Mate
I'm a fan of your very clear video tutorials, I would like to rely a question and hopefully I get an answer to your magnificent mind :)
If I combine 2 excel file (with same data structure), and same data but no date column, I only rely to ID (unique) to remove duplicates.
My problem is, when I change something inside one column(update), it does not overwrite and still retain the old data since I'm referring only to a ID.
How can I solve this issue in which if theirs an update it will adapt the new data as output, not the old data?
Thank you in advance Chandeep, more power!!!All Support

[Eric-qmvm]

Thanks so much!!! Your videos are fantastic. I’d like to ask you a few questions, hope you can help. 1. Is there a way to pull data from a workbook with uneven data structure? Imagine a workbook with several bordered groups. Each group represents a job site and the names of staff members assigned to work there. Some job sites have multiple bordered groups due to multiple shift requirements 1st, 2nd and 3rd shifts. During the day, all staffing changes are made on this main workbook. For example, if a staff member calls out of work sick it is indicated next to his name where he is assigned to work. The job site bordered groups are in various ranges. Therefore columns are rows are not consistent or even matched. Is there a way to pull data like Sick call outs, vacation, etc on a worksheet like this?
Question #2. Is it possible to automate dates on multiple sheets with uneven data structure? I am required to update the same dates on all 3 sheets in excel. All 3 sheets are structured differently and the date locations are in various cell ranges.. can this be automated by entering the date only on the 1st page? Thank you so much.

[markjansenlk]

Thanks for the very informative video, I have following questions;
- Can I adjust the column width of the final sheet to stay fixed during refresh operation?
- Can i protect the final sheet and still do the refresh?

[sushantsharma]

Is there any way to eliminate specific rows from all sheet before close and load

[SFLLibya]

Thank you very very very much, it was really helpfull,
URGENT Q- can i separate the combined files by inserting each combined file's name before it's data?
example : file year - 2005 then data, then cell contains "file name : year 2006" then data, ,,etc ???

[shoppersdream]

Thank you! What happened to the empty row you added on the top? I didn't see that you removed the empty row. Let us say that there is data in rows 2 and 3 and you don't want to show them. What would you do? You don't want these 2 and 3 rows to append after every table.

[BBBBBB]

great video. Can you help or point me to the right video that will help me combine the rows in power query like you combined the columns?

[Yatender_Yatender]

Sir need one help, I have connected power query with a folder and folder contains multiples files with different dates and I want to filter only specific dates data pls help-out
Even I tried to make date filter as a function but don't know how to connect it with editor option
Request to please help out..

[maralrodriguez]

Really really helpful! A BIG THANK YOU!