Spreadsheet: 635999d1565106896-4-names-in-one-row-split-into-one-row-for-each-name-split-into-firstname-and-surname-sample-argyll-pa28-
Sheet: Amended Layout

[NAME] | Property Ref | UPRN | PropertyAdd1 | PropertyAdd2 | PropertyAdd3 | PropertyAdd4 | PropertyPostcode | Firstname | Surname
400002325 | 10024107 | 125001896 | 1 Street Name | Locality1 | Town1 |  | XX12 XSB | [NAME] | Campbell
400002349 | 10040860 | 125001919 | 2 Street Name | Locality2 | Town2 |  | XX12 XSB | [NAME] | Hopkins
400002349 | 10040860 | 125001919 | 2 Street Name | Locality2 | Town2 |  | XX12 XSB | D | Hopkins
400002349 | 10040860 | 125001919 | 2 Street Name | Locality2 | Town2 |  | XX12 XSB | L | Hopkins
400002373 | 10057613 | 125001942 | 3 Street Name | Locality3 | Town3 |  | XX12 XSB | [NAME] | [NAME]
400002373 | 10057613 | 125001942 | 3 Street Name | Locality3 | Town3 |  | XX12 XSB | [NAME] | [NAME]
400002373 | 10057613 | 125001942 | 3 Street Name | Locality3 | Town3 |  | XX12 XSB | Lesley | [NAME]
400002373 | 10057613 | 125001942 | 3 Street Name | Locality3 | Town3 |  | XX12 XSB | B | [NAME]
400002397 | 10074366 | 125001965 | 4 Street Name | Locality4 | Town4 |  | XX12 XSB | [NAME] | Campbell
400002397 | 10074366 | 125001965 | 4 Street Name | Locality4 | Town4 |  | XX12 XSB | Mr | Campbell
400002421 | 10091119 | 125001988 | 5 Street Name | Locality5 | Town5 |  | XX12 XSB | [NAME] | Richards
400002445 | 10107872 | 125002011 | 6 Street Name | Locality6 | Town6 | Locality6 | XX12 XSB | K | Jordan
400002445 | 10107872 | 125002011 | 6 Street Name | Locality6 | Town6 | Locality6 | XX12 XSB | B | Jordan
400002661 | 10124625 | 125002034 | 15 Street Name | Locality15 | Town15 |  | XX12 XSB | ACHA
400002685 | 10141378 | 125002057 | 16 Street Name | Locality16 | Town15 |  | XX12 XSB | L | [NAME]
400002685 | 10141378 | 125002057 | 16 Street Name | Locality16 | Town15 |  | XX12 XSB | J | [NAME]
400002685 | 10141378 | 125002057 | 16 Street Name | Locality16 | Town15 |  | XX12 XSB | T | [NAME]
400002709 | 10158131 | 125002080 | 17 Street Name | Locality17 | Town15 |  | XX12 XSB | T | Kelly
400002709 | 10158131 | 125002080 | 17 Street Name | Locality17 | Town15 |  | XX12 XSB | Emma | Vardy
400002733 | 10174884 | 125002103 | 18 Street Name | Locality18 | Town15 |  | XX12 XSB | Christian | [NAME]
400002733 | 10174884 | 125002103 | 18 Street Name | Locality18 | Town15 |  | XX12 XSB | [NAME] | [NAME]
400002733 | 10174884 | 125002103 | 18 Street Name | Locality18 | Town15 |  | XX12 XSB | Kelly | [NAME]
400002733 | 10174884 | 125002103 | 18 Street Name | Locality18 | Town15 |  | XX12 XSB | [NAME] | [NAME]
400002757 | 10191637 | 125002126 | 19 Street Name | Locality19 | Town19 |  | XX12 XSB | [NAME] | Hollis
400002757 | 10191637 | 125002126 | 19 Street Name | Locality19 | Town19 |  | XX12 XSB | Lara | Hollis
400002781 | 10208390 | 125002149 | 20 Street Name | Locality20 | Town20 |  | XX12 XSB | ABC Building Supplies Limited
400002805 | 10225143 | 125002172 | 21 Street Name | Locality21 | Town21 |  | XX12 XSB | [NAME] | Sharp
400002805 | 10225143 | 125002172 | 21 Street Name | Locality21 | Town21 |  | XX12 XSB | Jake | [NAME]
400002805 | 10225143 | 125002172 | 21 Street Name | Locality21 | Town21 |  | XX12 XSB | [NAME] | [NAME]
400002805 | 10225143 | 125002172 | 21 Street Name | Locality21 | Town21 |  | XX12 XSB | [NAME] | [NAME]
400002829 | 10241896 | 125002195 | 22 Street Name | Locality22 | Town22 |  | XX12 XSB | Trustees of The Church of Scotland
400002853 | 10258649 | 125002218 | 23 Street Name | Locality23 | Town23 | Locality6 | XX12 XSB | [NAME] | McCallum
400002853 | 10258649 | 125002218 | 23 Street Name | Locality23 | Town23 | Locality6 | XX12 XSB | Caleb | McGeachy
400002853 | 10258649 | 125002218 | 23 Street Name | Locality23 | Town23 | Locality6 | XX12 XSB | Adrian | Sidor
400002877 | 10275402 | 125002241 | 24 Street Name | Locality24 | Town23 | Locality7 | XX12 XSB | Cole | McCallum
400002877 | 10275402 | 125002241 | 24 Street Name | Locality24 | Town23 | Locality7 | XX12 XSB | Jan | Campbell
400002901 | 10292155 | 125002264 | 25 Street Name | Locality25 | Town25 | Locality8 | XX12 XSB | Walter | McCulloch
400002925 | 10308908 | 125002287 | 26 Street Name | Locality26 | Town26 |  | XX12 XSB | [NAME] | Martin
400002925 | 10308908 | 125002287 | 26 Street Name | Locality26 | Town26 |  | XX12 XSB | [NAME] | Martin
400002925 | 10308908 | 125002287 | 26 Street Name | Locality26 | Town26 |  | XX12 XSB | [NAME] | Martin
400002949 | 10325661 | 125002310 | 27 Street Name | Locality27 | Town27 |  | XX12 XSB | [NAME] | Mellish
400002949 | 10325661 | 125002310 | 27 Street Name | Locality27 | Town27 |  | XX12 XSB | Veronica | Mellish
400002949 | 10325661 | 125002310 | 27 Street Name | Locality27 | Town27 |  | XX12 XSB | Vera | Mellish
400002949 | 10325661 | 125002310 | 27 Street Name | Locality27 | Town27 |  | XX12 XSB | [NAME] | Mellish
400002973 | 10342414 | 125002333 | 28 Street Name | Locality28 | Town28 |  | XX12 XSB | [NAME] | [NAME]
400002973 | 10342414 | 125002333 | 28 Street Name | Locality28 | Town28 |  | XX12 XSB | Fay | [NAME]
400002973 | 10342414 | 125002333 | 28 Street Name | Locality28 | Town28 |  | XX12 XSB | [NAME] | [NAME]
400002973 | 10342414 | 125002333 | 28 Street Name | Locality28 | Town28 |  | XX12 XSB | [NAME] | [NAME]
400002997 | 10359167 | 125002356 | 29 Street Name | Locality29 | Town29 |  | XX12 XSB | Argyll & Bute Council Private Rentals
400003021 | 10375920 | 125002379 | 30 Street Name | Locality30 | Town30 |  | XX12 XSB | Fyne Homes Social Care Partnership Ltd
400003045 | 10392673 | 125002402 | 31 Street Name | Locality31 | Town31 | Locality14 | XX12 XSB | Morag | Jones
400003045 | 10392673 | 125002402 | 31 Street Name | Locality31 | Town31 | Locality14 | XX12 XSB | Rhys | Jones
400003045 | 10392673 | 125002402 | 31 Street Name | Locality31 | Town31 | Locality14 | XX12 XSB | [NAME] | Jones
400003045 | 10392673 | 125002402 | 31 Street Name | Locality31 | Town31 | Locality14 | XX12 XSB | Sheena | Jones
400003069 | 10409426 | 125002425 | 32 Street Name | Locality32 | Town32 |  | XX12 XSB | Cara | Stalker
400003069 | 10409426 | 125002425 | 32 Street Name | Locality32 | Town32 |  | XX12 XSB | Gregor | Semple
400003069 | 10409426 | 125002425 | 32 Street Name | Locality32 | Town32 |  | XX12 XSB | [NAME] | Morrison
400003069 | 10409426 | 125002425 | 32 Street Name | Locality32 | Town32 |  | XX12 XSB | [NAME] | [NAME]