Pivot column (Transform Data) with duplicate values

[arinyc]

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?

[ryan_mayu · Accepted solution]

@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