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
Attachment | Size |
---|---|
database example.xlsx | 10.01 KB |
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago