Excel - create new rows and parse a list of suburb names against the masthead title
The example is a list of newspapers.
On each row there are 6 columns containing information for that Masthead.
Column G contains a list of suburbs relevant to the masthead that is in the same row in column C.
The requirement is to create as many new rows for the masthead as there are suburbs, and copy the contents of the masthead rows from A to F into the new rows, and then copy each suburb separately into column B beside the masthead.
Rows 2 to 32 show three mastheads where this has been done manually. Suburb-to-newspaper-example.xlsx