I have an excel file with the names of bands and their genre.
Column A: bandname. Column B: genre.
The b column might contain multiple entries such as "pop/rock". I would want to split that into two rows.
Example:
- [1] Awesomeband | Pop/Rock
would be transformed to
- [1] Awesomeband | Pop
- [2] Awesomeband | Rock
How would I realise that within excel? Any clues? Thanks in advance.
See Question&Answers more detail:os