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
gregfthompsonAsked:
Who is Participating?
 
als315Commented:
Test this sample. Allow macros and press Run button
Suburb-to-newspaper-example-Macro.xlsm
0
 
gregfthompsonAuthor Commented:
Thank you.
Brilliant!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.