Hi all excel gurus,
I have a large dataset where I have a column of authors where the authors are split based on a semicolon; Now I need to split all these authors into an individual rows of record along with all the other data relative to that record should duplicate.
Is there some way I can make excel to look for the semicolon ; and split it to a separate row with all the other data kept intact?![]()
Can someone please help me how can I achieve that? Attached a sample spreadsheet for your reference. Thanks in advance.
Bookmarks