Separating multiple values for an ID into different columns

[dexterwoolfe]

I have 2 tables. A table with lead details and a table with contact info both have a LeadID column.

Some leads have several phone numbers and I just wanted to know how I can create a table with all the Lead IDs and the various phone numbers we have for them in seperate columns.

Thanks in Advance for any help

[v-jiascu-msft]

Hi @dexterwoolfe,

You can separate them using Split Column in the Query Editor.

Best Regards!

Dale

[dexterwoolfe]

Hi @v-jiascu-msft

Unfortunatley this wouldn't work in this instance as the various phone numbers aren't in the same cell. They are in a seperate table on different rows under the same 'LeadID.' Hopefully the below screenshot will clarify.

[v-jiascu-msft]

Hi @dexterwoolfe,

Could you please provide a dummy pbix file?

Best Regards!

Dale