Help needed to transfer disorganized data from columns to rows


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

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

Company Email

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

database example.xlsx10.01 KB