Reputation: 203
I have a huge data set that contains cells with multiple emails as depicted in the following picture:
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:
What is the best way to do that in Excel? What would be the formula for that?
Thanks,
Upvotes: 1
Views: 181
Reputation: 1719
Try this in power query
Upvotes: 1