Forum Discussion

Automater's avatar
Automater
New Member
3 years ago

Problem with "pivote column" function

Hello everybody, I have following problem: I depivote a table in power query going from this:  to this:  because I need to "translate" the values in the Column "Wert" with a second ta...
Need Help
BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi Max,

 

Try going to the Add Column tab > Index Column (dropdown) > From 1 BEFORE your last pivot step.

This should give Power Query an ID to use in order to reallocate values correctly to columns.

 

Pete

  • Automater's avatar
    Automater
    New Member
    3 years ago

    Hi Pete,
    thanks for your answer. I tried it and the output looked like this:

    The problem here is, that for example the values of line 1,2,3 and 4 should be in one line, here they're splitted.

    • BA_Pete's avatar
      BA_Pete
      Super User
      3 years ago

       

      Ok. Try dragging and dropping the Add Index step up your steps list to before your first Unpivot.

      This should give you ID groups after the unpivot that PQ will group back up correctly after the final pivot.

       

      Pete

      • Automater's avatar
        Automater
        New Member
        3 years ago

        Tried it too.

        I added an index column before the first unpivot:

        And after the unpivot step it looks like this:

        But if I want to pivot it back again I still receive the same error... 

         

        Do you have any other tips?

         

        Thank you so much

        Max