Change Rows to Columns in Power Query

In this video, we look at changing data from a row to a column in Power Query. Sometimes the data you import or receive is not on one row, as it should be. It is split over multiple rows. And these rows need to be converted to columns to then analyse. This video demonstrates two examples of using Power Query to change rows to columns. Download the workbook to practise - https://www.computergaga.com/_excel/files/power-query/switch-row-to-column.xlsx 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!