Help needed to transfer disorganized data from columns to rows

Hi!

I have a database with several information in each "box" and would like to know if it's possible to automatically transfer and separate/split this from columns to rows. Not sure how to explain it so I'll attach an image with an example of what the information looks like (in blue) and how I would like it to be sorted (in yellow).

The first and last name is not as important as to be able to separate the emails into several rows:

Company Email
X John@x.com; matt@x.com; dave@x.com

I would like each email to be in a new row with all other data, e.g.:

Company Email
X john@x.com
X matt@x.com
X dave@x.com

is there an automatic way that I can do that wiht all records containing several data in one"box"?

Hope you can help out.

Have a nice day.

Cheers, Michael

AttachmentSize
database example.xlsx10.01 KB