locked
Auto Transpose using Power query RRS feed

  • Question

  • I was working with excel.

    And my requirement is to transpose the data automatically.

    like there is a table named as Table1 (Source Table). 

    Suppose currently it is having 4 rows and 5 columns.

    So i want that i will write formula in one cell and it automatically gets converted into 5 rows and 4 columns.

    I don't want to choose the Range for output results (i.e. for tranposed results)

    As in future the number of columns and rows may increase or decrease in my Source table  (i.e. Table1)


    Wednesday, January 25, 2017 5:13 AM

Answers

  • Create a Power Query query to transpose an initial table to Table1.

    Then change the source of that query to Table1, so input = output.

    Now the sheet with the initial table can be deleted.

    Watch the steps in this video.

    Wednesday, January 25, 2017 7:17 AM