Create subtable based on comma separated value in main table

[dancarr22]

Hello,

We are connecting to Dynamics 365 and - in several tables - we have multiselect pick lists.  i.e. When we enter a contact we can select multiple values of the 'contact type' for a given contact - example in table below.  John Smith is both a Salesperson and an Account Manager.

This contact field is displayed as a comma separated value in PBI table.  How can we break this out to display as a separate table?  We'd also want to have the contact name so can join back to main Contact table.  (In reality would use key/ID fields instead of name - thisis just for the example).

Appreciate any help you can provide.

Thanks,

Dan

[HotChilli · Accepted solution]

Split the 'Contact Type' column on ','

Select the 'Contact Name' and Address columns.

Go to the Transform Menu.

Select 'Unpivot-> Unpivot other columns'

Tidy up the data

[dancarr22]

Thanks!  That worked exactly as needed!

Greatly appreciate your assistance.