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

 

BA_Pete's avatar
BA_Pete
Super User
3 years ago

 

It looks like you've unpivoted the Index with the other columns.

Select your index column before the unpivot step, go to the Transform tab > Unpivot Columns (dropdown) > Unpivot Other Columns. This should keep your Index column intact to be used as an ID for the pivot step later.

 

If this doesn't work, can you provide your initial data from the following screenshot as copyable data please?

 

You can copy it from Excel and paste it directly in here, or you can paste it into 'Enter Data' in Power Query and copy the M code from that query.

 

Pete