asked on 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
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
Microsoft OfficeMicrosoft Excel
Last Comment
gregfthompson
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Brilliant!!