Sheet1 contains 9 columns - the key ID is the Postcode. Each postcode isbe repeated several times with different contents in the cells on each row for that postcode number.
Sheet2 contains 2 columns - Postcode, Local Zone. Each postcode is repeated several times with different numbers in the Local Zone column.
The requirement is to copy the row by postcode from Sheet1, into the row with the same postcode in Sheet2, and to repeat the copy as many times as there are different Local Zone numbers, and the create a new set of the same postcode/local zones for the next postcode from Sheet1. Each row in Sheet1 is created in Sheet2 for as many times as the LocalZone number occurs.
The example file shows the first postcode contents from Sheet1, copied manually into Sheet2.