Splitting multiple comma delimited cells into multiple rows, keeping row details

Hi all,   I'm looking to write a Power Query function or Excel macro which would transform something like the first example below into something like the second - does anyone please have any sugges...