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 ....