converting & spliting

  1. M

    help: converting data from column to row

    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...

Some videos you may like

This Week's Hot Topics