Forum Discussion
Casperserven1
Helper I
2 years agoConcatenate 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...
- 2 years ago
pls try this
Ahmedx
Super User
2 years agopls try this
Casperserven1
Helper I
2 years agoThanks 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 🙂
but thanks - you have pointed me in the right direction 🙂