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

NameemailRType
fred1"[email protected]"blue
fred2"[email protected]"blue
fred3"[email protected]"blue
fred4"[email protected]"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:

[email protected]; [email protected] ;[email protected]

 

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

Need Help

2 Replies

    • 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 🙂