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

Happy New Year everyone! 🎉
A little New Year's favour, will you please give this video a like and subscribe to the channel? This will really help me hit my 2023 goal of 50,000 subscribers! Thank you 🙏 have a great new year!

Great

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.

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

@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.

Your information is good but lengthy unable to understanding,

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.

My saviour 🙌😅🙏 excellent video!

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

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

👍👍👍, can you share the files

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

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?

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

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

Very clear demo given. Thank you.

Cool! Thanks!!

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.👍👏🤝