Multiple email addresses for the same contact need to separated

[brittesser]

I have csv file from a client that has the name of the contact and then up to 3 different email addresses. I need the contact name to have a separate row for each email address. Thanks for your help.

 

[lrobbo314]

You can use Power Query and unpivot the email columns.

 

[alansidman]

Cannot manipulate data in a picture. Please reload your data using XL2BB. Can unpivot the data with Power Query