Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Turning values in a column into column headers sorted by warenumber

Hey,  So I have an issue in the way parts of the data stored in our database needs to be rearranged.    In the above picture, column "type" contains four different values. I would instead ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    How did you pivot the column [Type] in Power Query Editor? Could you please provide the related applied codes in Advanced Editor? Thank you.

    In addition, you can apply the below code in your Advanced Editor to achieve it.

    = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Type]), "Type", "kNummer")

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Sorry for the late reply. You're probably right. I've been trying to make it work, but I cannot get it quite right. 


In the above we have the 2 Genart values as columns, which is correct, but instead of 1 / 0 I'd like it to display the value from the (now deleted) kNummer column. Any clues on how to get this to work? 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

How did you pivot the column [Type] in Power Query Editor? Could you please provide the related applied codes in Advanced Editor? Thank you.

In addition, you can apply the below code in your Advanced Editor to achieve it.

= Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Type]), "Type", "kNummer")

Best Regards