Spreadsheet: 890076d1741232613-4-names-in-one-row-split-into-one-row-for-each-name-split-into-firstname-and-surname-sample-argyll-pa28-
Sheet: ABC LDM Name Splitter

UPRN | Address 1 | Address 2 | Address 3 | Address 4 | Address 5 | Postcode | Person 1 | Person 1 Email | Person 2 | Person 2 Email | Count Names | Cumulative | UPRN | Address 1 | Address 2 | Address 3 | Address 4 | Postcode | Name | First Name | Middle Name | Surname | [NAME] |  |  | UPRN | Address 1 | Address 2 | Address 3 | Address 4 | Address 5 | Postcode | Name | First | Middle | Surname | [NAME]
125055638 | 102 | 7 East Princes Street | Rothesay | Bute |  | PA20 9DL | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Title List
125000629 | 23 Glenview | Dalmally |  |  |  | PA33 1BE | Mr [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0 |  |  |  | 0
125056324 | G02 . | 12 The Terrace | Ardbeg Road  Rothesay | Bute |  | PA20 0NP | Mr [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mrs |  | 125000629 | 23 Glenview | Dalmally | 0 | 0 | 0 | PA33 1BE | Mr [NAME] |  |  |  | [EMAIL]
125089289 | 2 Eton Avenue | [NAME] |  |  |  | PA23 8DG | Miss [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Miss |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0 |  |  |  | 0
125001257 | 7 . | 1 Park Lane | [NAME] |  |  | G84 7NT | Mr [NAME] |  | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  | Master |  | 125056324 | G02 . | 12 The Terrace | Ardbeg Road  Rothesay | Bute | 0 | PA20 0NP | Mr [NAME] |  |  |  | 0
125014105 | 202 | 5 Kirk Street | Campbeltown |  |  | PA28 6BL | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mstr |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0 |  |  |  | 0
125027228 | 3 Chamberlains House | Front Street | Inveraray |  |  | PA32 8UY | Mr [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr |  | 125089289 | 2 Eton Avenue | [NAME] | 0 | 0 | 0 | PA23 8DG | Miss [NAME] |  |  |  | [EMAIL]
125021377 | 10E Longsdale Terrace | Oban |  |  |  | PA34 5JS | Mr [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rev |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0 |  |  |  | 0
125030032 | 12 Rosedale Gardens | East Princes Street | [NAME] |  |  | G84 7RW | Ms Fiona C Gillies |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lord |  | 125001257 | 7 . | 1 Park Lane | [NAME] | 0 | 0 | G84 7NT | Mr [NAME] |  |  |  | 0
125019363 | Flat 2  Dalintober House | North Shore Street | Campbeltown |  |  | PA28 6EH | Miss [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ms |  | 125001257 | 7 . | 1 Park Lane | [NAME] | 0 | 0 | G84 7NT | [NAME] |  |  |  | [EMAIL]
125024454 | 32 [NAME] | [NAME] |  |  |  | PA23 8NR | Mr [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125014105 | 202 | 5 Kirk Street | Campbeltown | 0 | 0 | PA28 6BL | [NAME] |  |  |  | 0
125023901 | 16 Keil Court | Hanover Street | [NAME] |  |  | G84 7AW | Eilidh O [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0 |  |  |  | 0
125042896 | 49 [NAME] | [NAME]'s Quay | [NAME] |  |  | PA23 8LB | Mr [NAME] | [EMAIL] | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125027228 | 3 Chamberlains House | Front Street | Inveraray | 0 | 0 | PA32 8UY | Mr [NAME] |  |  |  | 0
125021185 | Buckhyne | 5 Shore Road | Carradale | Campbeltown |  | PA28 6SH | Miss [NAME] | [EMAIL] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0 |  |  |  | 0
125056404 | 1 [NAME] (1st Floor) | Kilchattan Bay | Rothesay | Bute |  | PA20 9NW | [NAME] | [EMAIL] | Mr [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125021377 | 10E Longsdale Terrace | Oban | 0 | 0 | 0 | PA34 5JS | Mr [NAME] |  |  |  | [EMAIL]
125008313 | Flat 1/1 | 33 East Princes Street | Rothesay | Bute |  | PA20 9DN | Mr [NAME] | [EMAIL] | Mrs Gayle I J Madden |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0 |  |  |  | 0
125071406 | Lime Kiln Cottage | Isle Of Gigha |  |  |  | PA41 7AD | Mrs Jean F M Brownie | [EMAIL] | Mr [NAME] Brownie | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125030032 | 12 Rosedale Gardens | East Princes Street | [NAME] | 0 | 0 | G84 7RW | Ms Fiona C Gillies |  |  |  | 0
125052790 | 4 Woodside | Isle Of Gigha |  |  |  | PA41 7AD | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125019363 | Flat 2  Dalintober House | North Shore Street | Campbeltown | 0 | 0 | PA28 6EH | Miss [NAME] |  |  |  | [EMAIL]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125024454 | 32 [NAME] | [NAME] | 0 | 0 | 0 | PA23 8NR | Mr [NAME] |  |  |  | [EMAIL]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125023901 | 16 Keil Court | Hanover Street | [NAME] | 0 | 0 | G84 7AW | Eilidh O [NAME] |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125042896 | 49 [NAME] | [NAME]'s Quay | [NAME] | 0 | 0 | PA23 8LB | Mr [NAME] |  |  |  | [EMAIL]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125042896 | 49 [NAME] | [NAME]'s Quay | [NAME] | 0 | 0 | PA23 8LB | [NAME] |  |  |  | [EMAIL]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125021185 | Buckhyne | 5 Shore Road | Carradale | Campbeltown | 0 | PA28 6SH | Miss [NAME] |  |  |  | [EMAIL]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125021185 | Buckhyne | 5 Shore Road | Carradale | Campbeltown | 0 | PA28 6SH | [NAME] |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125056404 | 1 [NAME] (1st Floor) | Kilchattan Bay | Rothesay | Bute | 0 | PA20 9NW | [NAME] |  |  |  | [EMAIL]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125056404 | 1 [NAME] (1st Floor) | Kilchattan Bay | Rothesay | Bute | 0 | PA20 9NW | Mr [NAME] |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125008313 | Flat 1/1 | 33 East Princes Street | Rothesay | Bute | 0 | PA20 9DN | Mr [NAME] |  |  |  | [EMAIL]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125008313 | Flat 1/1 | 33 East Princes Street | Rothesay | Bute | 0 | PA20 9DN | Mrs Gayle I J Madden |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125071406 | Lime Kiln Cottage | Isle Of Gigha | 0 | 0 | 0 | PA41 7AD | Mrs Jean F M Brownie |  |  |  | [EMAIL]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125071406 | Lime Kiln Cottage | Isle Of Gigha | 0 | 0 | 0 | PA41 7AD | Mr [NAME] Brownie |  |  |  | [EMAIL]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125052790 | 4 Woodside | Isle Of Gigha | 0 | 0 | 0 | PA41 7AD | [NAME] |  |  |  | [EMAIL]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0 |  |  |  | 0