Hi,
I want to analyse bibliographical data with excel and I need to split up data from one cell (author names, seperated by semicolon) and then convert it into new rows. Then I have to populate the data from the other cells to the new rows.
Here is a screenshot of the data:
...and this is how the data from the first row should look like after the conversion:
I would be grateful for any help!
Thanks a lot!
Matt
I want to analyse bibliographical data with excel and I need to split up data from one cell (author names, seperated by semicolon) and then convert it into new rows. Then I have to populate the data from the other cells to the new rows.
Here is a screenshot of the data:
![001_original_data.png](/board/proxy.php?image=http%3A%2F%2Fwww.tarikapuy.de%2F001_original_data.png&hash=4450d7195269e648a797855a208ba29a)
...and this is how the data from the first row should look like after the conversion:
![002_converted_data.png](/board/proxy.php?image=http%3A%2F%2Fwww.tarikapuy.de%2F002_converted_data.png&hash=5723d9fa70faf2fd6a849f94058d4d1e)
I would be grateful for any help!
Thanks a lot!
Matt