Forum Discussion

Casperserven1's avatar
Casperserven1
Icon for Helper I rankHelper I
2 years ago
Solved

Concatenate values from column for export on one row.

Hi - my req requirement is to take a bunch of names and email addresses in my data, limit them down by another column then display the limited data on one line that can be exported into email or MSTe...
Need Help
  • Casperserven1's avatar
    Casperserven1
    Icon for Helper I rankHelper I
    2 years ago

    Thanks Ahmedx - that works execept I need unique values, the data sample is not representantive - I have multiple columns and email repeated many time - something like 

     

    SUMMARIZE( 'Stakeholder List','Stakeholder List'[Workstream],"email", CONCATENATEX( 'Stakeholder List','Stakeholder List'[StakeholderEmail]," ; "))

    but thanks - you have pointed me in the right direction 🙂