Convert "list" to "line"

excel
activities

#1

I’ve got a list of e-mail addresses in excel table (column) and want to convert it into one line with “;” so I could send one email to all recipients.
What is the best way to do it?


#2

#3

@pjw
String.Join(";", lstEmails.Distinct())
where lstEmails is your list
Distinct is used to eliminate the repeating values if exists any


#4

Thank you for your answer, however it doesn’t bring me closer to solution…
I have an excel list with 100.000 rows and 2 columns Project Number and Customer Email. It could more then 1 Customer per project. I want to send email to each customer for given Project Number.
What would be the simplest way for it? (attached shorten list)
Thanks in advance
result.xlsx (9.5 KB)