CODEWITHSUNDEEP
excelexcel-formula
Ali
Ali

Reputation: 203

Separating email addresses in Excel

I have a huge data set that contains cells with multiple emails as depicted in the following picture:

enter image description here

As you can see that 3 emails are associated with X

I want to split the multiple emails and shift them down without affecting the other cells. The below picture illustrated the expected solution:

enter image description here

What is the best way to do that in Excel? What would be the formula for that?

Thanks,

Upvotes: 1

Views: 181

Answers (1)

Imran Malek
Imran Malek

Reputation: 1719

Try this in power query

  1. Click on Home tab in Power Query, select Split Column, by Delimiter.
  2. Power Query will analyze your data and detect the delimiter.
  3. Click on Advanced Options->Split Into section, choose Rows.

Upvotes: 1

Related Questions