Split Cell by Delimiter, Move to New Row, Copy contents of cells on original row

I was wondering if anyone can help me with the following.

My excel sheet has 1413 rows with data in columns A - K

Column K contains a string of characters separated by ; delimiter.(approx 8 max or as few as 1). Where there is only 1 there is no ; deliminator.

Columns A - J contain additional information about the ; delimitated data in column K

For reference the name of column K is called "Location"
This column needs to be split apart by ; and the separate Locations that result from splitting apart by ; needs to be placed on a separate line. Once each Location is on a separate line, all of the Locations need to be lined up in Column K, one under another.
Next, i need all of the data that is contained in each originating row (so text from columns A - J to be copied down to each of newly created rows)

I've tried the "text to columns" option but this splits to contents of column K across to the right and not down onto a new line. I need the delimitated text to appear on new lines underneath in column K along with the contents of columns A-J

Any help would be greatly appreciated