I need an advice on the following situation.
I have column that is single line of text which stores email addresses separated by comma (the value is created by lookup table).
I want to convert it to:
I need to convert it so that I can send an email out.
Any existing solution or advice will be appreciated.
I am using SharePoint 2013.