Trick 008 Rotate a vertical data table to horizontal with power query

When you create datasets, you frequently have to a vertical data table to horizonta. 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.