Forum Discussion

dexterwoolfe's avatar
dexterwoolfe
Frequent Visitor
8 years ago

Separating multiple values for an ID into different columns

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

Need Help

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi dexterwoolfe,

     

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

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

    • dexterwoolfe's avatar
      dexterwoolfe
      Frequent Visitor
      8 years ago

      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.