Forum Discussion

arinyc's avatar
arinyc
Helper I
4 years ago
Solved

Pivot column (Transform Data) with duplicate values

Hi,

 

I want to transform my data using pivot column option (column "Role") where "Contact role name" is values column.

This is my Pivot column settings:

Error shows up because there are duplicate names in the "Contact role name" column related to the same "Role" (Originator) in the origin table

 

My question is - how can I overcome this situation and see two lines in the resulting table showing one originator name per line?

 

Need Help
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    arinyc 

    maybe you can try this

    1. group by 

    = Table.Group(#"Changed Type", {"18", "product line", "ROLE"}, {{"contact name", each Text.Combine([contact role name],"/"), type text}})

    2. pivot column

    3. split column

    pls see the attachment below

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    4 years ago

    arinyc 

    maybe you can try this

    1. group by 

    = Table.Group(#"Changed Type", {"18", "product line", "ROLE"}, {{"contact name", each Text.Combine([contact role name],"/"), type text}})

    2. pivot column

    3. split column

    pls see the attachment below