How to Combine Multiple Files with Inconsistent Column Headers into a Single Sheet 

Be among the first 100 to jump on board "The Query Editor" newsletter 🚀. It's packed with super-actionable tips and insights. Why should you be excited? 🌟 Because the first 100 subscribers will receive an exclusive 50% discount on my upcoming mini-course, set to drop early next year (or perhaps even sooner)! 🤞Just hit this link to subscribe thequeryeditor.beehiiv.com/subscribe 🚀🔥

Just what I've been looking for. Thank you for this video

Very clear demo given. Thank you.

You're a life saver. It worked like a charm

Another very important video which is a MUST requirement of any person who is using Power Query. I am a big fan of your teaching methods and contents. The contents are up to the mark and very much helpful in routine work.👍👏🤝

Very useful. I've been adding holidays manually, until now!

Cool! Thanks!!

Thank you so much. A very intuitive video. Question though... what if the null values or errors stated at the 950000th row and all the rows in from of me looked ok?

Absolute beast

Hello dear big thanks for such vedio but when i tried to update renamed file i faced error: we expected a rename operation value details list,,that was in tranform sample file

Great

Hi Miss M, Hello, thank you for your knowledge. How would it be done if you have to delete rows and then promote the headers, how would the method be that way, since the file you use as an example, those headers are already promoted?

9:27 the Missingfield.Ignore parameter was magic. I thought it was going to be tricky to deal with all the columns that didn’t need to be renamed.

In same sheet multidate date past but header jump to another column,that how to slove it

Hello, I am working on multiple data feed files and every vendor has got multiple columns of data with inconsistent data. I wanted to merge all the files by filtering only selected columns into my final spreadsheet. Any assistance is much appreciated.

Hello...what about custom function to be as sample file ?

hello my dear Miss Microsoft, it must be specified that the names of spreadsheets have the same name, for example "Sheet1", otherwise there will be an error...your friend MOUSSA from Algeria

Could you help me regarding this doubt I have 2 Excel files First file having 10 customers data (unique ID no., name Age, salary). Second file has 15 customers data (unique ID no., name Age, salary). But both files have 7 common customers. I want that, if my changes 1st file data (salary data) of some customer .The changes should be automatically updated in 2nd file for that customer. Example: If I change the salary of a person (in 1st file), then Excel should identify the unique ID no. (In 1st file) And after that Excel will automatically search this unique ID no. In 2nd file and after searching, Excel will update salary for that unique ID no.

👍👍👍, can you share the files

Hi ! I'm running into the following issue: At 9:52 I get this error: Expression. Error: The field 'X' already exists in the record Name = X Value = Any idea what the issue might be?

@Miss Microsoft, I just subscribed! I am not a coder, but i run my own real estate business and all of the CRMs fail at allowing me to quickly add a csv from any source onto their platform and I am looking at Sheets or Excel as a first step. The info is similar, but headers vary and so does the data. Ie, name, might be first, last or or parsed as first name, last name. Some sheets may have property address and owner name and others may have more data I want to bring into a master Sheet or CRM. But, I do not want to do some type of clean up just to do that. How many cups of coffee would I need to buy you to get your input:-) I am hoping a CRM has created a built in formula. Salesforce has very strict rules and I'd have to always clean up files, so I don't want to use them. I am open to using Sheets or Excel, which I don't currently have, but if it's easier to do on Excel, I'd love your input. If I solve for combining, maybe I can then use any CRM with a Master list.

Excellently explained! you got a new sub here. May I mention also that you are beautiful too.

Your information is good but lengthy unable to understanding,