Forum Discussion

SebSchoon1's avatar
SebSchoon1
Post Patron
4 years ago
Solved

Transpose column with repeated values

Hi guys,   I'm asking myself if it is possible to split rows on "Attribute" column resulted from an unpivot function.   heres the code at the point i have my duplicates on lines due To Qty and Si...
Need Help
  • SebSchoon1's avatar
    SebSchoon1
    4 years ago

    My Bad, 

     

    Posting to fast, 

     

    i have been able to manage it.

     

    -I created a Index column

    -I created a conditionnal column ( If [Attribut] = "Season") then "XITEMX"&[Index] else Null

    - I drop down values.

    -I aggregate tables with = Table.Group(#"Colonnes supprimées1", {"Personnalisé"}, {{"allrows", each _, type table [Attribut=text, Valeur=text, Personnalisé=text]}})

    -I transpose each tables in a new column

    ==> = Table.AddColumn(#"Lignes groupées", "Personnalisé.1", each Table.Transpose([allrows]))

     

    Promote headers,

     

    Expand 🙂

SebSchoon1's avatar
SebSchoon1
Post Patron
4 years ago

My Bad, 

 

Posting to fast, 

 

i have been able to manage it.

 

-I created a Index column

-I created a conditionnal column ( If [Attribut] = "Season") then "XITEMX"&[Index] else Null

- I drop down values.

-I aggregate tables with = Table.Group(#"Colonnes supprimées1", {"Personnalisé"}, {{"allrows", each _, type table [Attribut=text, Valeur=text, Personnalisé=text]}})

-I transpose each tables in a new column

==> = Table.AddColumn(#"Lignes groupées", "Personnalisé.1", each Table.Transpose([allrows]))

 

Promote headers,

 

Expand 🙂