Link to home
Create AccountLog in
Avatar of gregfthompson
gregfthompsonFlag for Australia

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
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of gregfthompson

ASKER

Thank you.
Brilliant!!