Combine Files with DIFFERENT Headers in Power Query | TWO Examples
Computergaga
@computergagaAbout
Welcome to my channel where you can expect videos on Excel tips and formulas to help you in your day to day work. Videos on using the latest Excel features, formulas, advanced Excel tips, VBA and Power BI. If you have a question, please ask. I try to reply to as many comments as I can. My apologies if I do not respond. It is very difficult to respond to everybody. Who am I? My name is Alan, I'm a Microsoft MVP and I have been training people how to get the most from Excel for over 20 years. I am the author of two Excel books "Advanced Excel Success" and "Advanced Excel Formulas". I love working with data and helping people improve their Excel skills and save time. I live in a town called Ipswich in the UK and I'm a father to two wonderful kids.
Latest Posts
Video Description
Combine files with different headers in Power Query. This video will show you two examples to combine Excel files despite the different headers. In the first example, the headers are different but the columns are in the same position. In the second example, the headers are different and the order of the columns is different. We will use a simple Power Query M function for this method. Video timings. 00:00 Introduction 00:40 Combine Excel files with different headers 05:54 Combine when the columns are in a different order 07:29 Table.RenameColumns M function Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1
You May Also Like
Upgrade Your Gear: Camera Bags
AI-recommended products based on this video
