Combine Files with DIFFERENT Headers in Power Query | TWO Examples

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