Forum Discussion

Eric_SCF's avatar
Eric_SCF
Regular Visitor
2 years ago
Solved

Transposing multiple times?

Hello, A newbie here to Power Query.  With a minimum of "programming" I would like to transpose this:   Product Sub1.1 Sub1.2 Sub1.3 Sub2.1 Sub2.2 Sub2.3 Sub2.4 Sub3.1 Sub3.2 Sub3.3 ...
Need Help
  • Omid_Motamedise's avatar
    Omid_Motamedise
    2 years ago

    Consider your table in power query as bellow


    then right-click on the product column and pick Unpivot other collumns to reach the next result.

     

Eric_SCF's avatar
Eric_SCF
Regular Visitor
2 years ago

Thank you jgeddes as well!  Appreciate the feedback.