Multiple emails for one lead

Hey guys,

I have a spreadsheet of a few thousand leads.

Each lead I'm going after has multiple emails separated by a comma in the 'Email' column.

I need it so each email for each lead is separated into a new row.


For example

Row one, lead one, email 1,2,3,
row two, lead two, email 1,2,3,

What I need this to be transformed into is:

Row one, lead one, email 1
Row two, lead one, email 2
Row three, lead one, email 3

and so on, if that makes sense?



Sample data is attached too.
It is not confidential or sensitive as this is all available on Google maps


Thank you to anyone that can help!!!


Cheers

Louis