Multiple rows from a single record?

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.