How to convert entire DataTable column into a string?

[IrinaMihalache]

Hello,

I have an Excel file with 2000+ rows and it containing a column "Email Address". I have to concatenate all rows on that column, put a ";" between them and then paste that huge string into a "TO" field and send an email.

I tried looping throw all rows one by one and create that huge string but it takes too much time. Is there any solution for this, without using the Loop?
(TEXTJOIN and CONCAT functions from Excel apparently limit the numbers of values/characters you can merge, so for my 2000+ rows excel column it's not working)


Email Address
----------------
email 1
email 2
email 3
email 4
.
.
.
email 2000

Wanted result: "email 1; email 2; email 3; email 4;.........;email 2000"

[whitehouse-UoL]

Hi All,
Thank you for you help on this question. 
@devneetmohanty07  Your Solution worked perfectly. 

Thanks again @devneetmohanty07 , @IrinaMihalache @ewilson . @Denis__Dennehy 

Have a great rest of the week. 

David