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

asked on

Excel - create new rows and parse a list of call signs names against the postcode

The example is a list of call signs for radio & tv stations
On each row there are 5 columns containing information for that postcode
Column D contains a list of postcodes relevant to the call signs that are in the same row in column E.

The requirement is to create as many new rows for the postcode as there are call signs, and copy the contents of the postcode rows rows from A to D into the new rows, and then copy each call sign separately into column E beside the beside the postcode.
Rows 2 to 8 from Base worksheet have been copied manually into rows 2 to 101 in Required worksheet.
2017-11-21-Radio---TV-call-sign-to-.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

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.
Worked perfectly.