How to Combine Multiple Files with Inconsistent Column Headers into a Single Sheet
HTML-код
- Опубликовано: 9 дек 2022
- Easily combine data with different column headers with these four steps. And when new data is added you just need to hit refresh and your data is updated automatically even if your new data has completely different column names to your original data!
✅ Please see link to videos mentioned in this video:
🎦 Power Query Advanced Editor - What Is It and How to Use It? - • Getting Started with t...
🎦 Power Query Error Handling - How to Deal with Power Query Errors Part 1 - • Power Query Error Hand...
✅ If you would like to connect on LinkedIn:
🤝 www.linkedin.com/in/missmicrosoft
✅ If you would like to support the channel by buying me a coffee, (it's really quick and easy), please use this link:
☕www.buymeacoffee.com/missmicr...
✅ For more videos please subscribe:
🔔 / @missmicrosoft
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
You're a life saver. It worked like a charm
Very clear demo given. Thank you.
You’re most welcome
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.👍👏🤝
Thank you so much Zahoor! Your support is greatly appreciated!
Very useful. I've been adding holidays manually, until now!
I’m glad the video was helpful!
Cool! Thanks!!
You’re welcome Wayne!
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
Thank you!
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
Why not just drill down & use List.transform followed by List.Union to get merged tables with unique columns?
In same sheet multidate date past but header jump to another column,that how to slove it
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?
You're most welcome David! I will make a video on this, please hit the notification bell so you know when that video is released.
Hi David, I’ve made the video, please check it out, hope it helps!: ruclips.net/video/N8LF9hso2M0/видео.html
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.
Great
Thank you!
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.
Glad you found it magical :), it's always great to find these solutions.
Hello...what about custom function to be as sample file ?
Hi! Yes that would definitely work!
@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.
Thank you for subscribing! Please email me your query with examples of what you have and what you require to Missmicrosoft@ignite-work.com and I will see if I can assist :)
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.
I think this may help you:
ruclips.net/video/RK8BkbjzROo/видео.html
Excellently explained! you got a new sub here. May I mention also that you are beautiful too.
Thank you for the support 🙏
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 MOUSSA, yes you're right, thanks for that extremely important point!
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?
Hi, I think it could be that you have a grouping field where the title of that group is the same as one of your field names, maybe change the title of that grouping field so that it's unique from the field names.
Thanks!
How should I do if I have 2 of my files with a "day" header and 2 others with a "date" header? Cause I will keep running into this issue by attempting to rename them.
👍👍👍, can you share the files
Your information is good but lengthy unable to understanding,
Glad to hear the information is good! What should I change with the videos to make it better? I’m always looking to improve my videos, thank you for your input!
Less explaining for the simple steps would make it more bearable