Trick 007 Rotate horizontal table data to vertical with power query

     When you create datasets, you frequently have to rotate rows and columns. Excel lets you transpose data in any direction. Transposing data means converting columns into rows and rows into columns.

        With a simple data table like this, we have many ways to rotate the table right in excel like using: Paste Special,  TRANSPOSE Function, Combine INDIRECT and ADDRESS Functions ....

    But with a complex data table like this. We can't use the normal way or we have to take more time to rotate the table.

With Power Query, rotating tables like this is easy.

Link to download excel file.