Concatenate values from column for export on one row.

[Casperserven1]

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 MSTeams:

Name	email	RType
fred1	"fred1@dogs.com"	blue
fred2	"fred2@dogs.com"	blue
fred3	"fred3@dogs.com"	blue
fred4	"fred4@dogs.com"	red

So if I filter by RType of 'blue' I want to display a row of data that has the following (with a separator of ';') like so:

fred1@dogs.com; fred2@dogs.com ;fred3@dogs.com

I am thinking thinking this is a simple requirement but cant quite get it to work - any ideas?

[Ahmedx · Accepted solution]

pls try this

[Casperserven1]

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 🙂