001. Convert COLUMNS to ROWS in excel Power Query - when traditional TRANSPOSE fails!

Convert COLUMNS to ROWS in excel Power Query: It may seem trivial to transpose your data in Excel - Basically switch between columns and rows. However, when you need to do it on part of your data set, it suddenly becomes very cumbersome. This is where Power Query comes into play! (it is embedded in Excel 2016 and older and available as a "Power Query" add-in for older versions. All you need is a few clicks to unpivot your data! Link to other transpose lesson: ***3 ways:    • 009. Transpose your Excel Data with Exampl...   Channel content: switch columns to rows, convert columns to rows in excel power query, excel power query pivot rows to columns, convert rows to columns in power query query, messy data to tabular, Change Horizontal Data to Vertical, change horizontal data to vertical, how to change horizontal values to vertical in excel, horizontal data to vertical in excel, excel tutorial to switch rows to columns, transpose data in excel sheet, excel transpose without formula, microsoft excel #Excel #MsExcel #PowerQuery