Spreadsheet: 635160d1564599635-4-names-in-one-row-split-into-one-row-for-each-name-split-into-firstname-and-surname-sample
Sheet: Original Layout

[NAME] | Property Ref | UPRN | PropertyAdd1 | PropertyAdd2 | PropertyAdd3 | PropertyAdd4 | PropertyPostcode | AA1Name1 | AA1Name2 | AA1Name3 | AA1Name4
400002325 | 10024107 | 125001896 | 1 Street Name | Locality1 | Town1 |  | XX12 XSB | ACHA
400002349 | 10040860 | 125001919 | 2 Street Name | Locality2 | Town2 |  | XX12 XSB | [NAME] | Mr D Hopkins | L Hopkins
400002373 | 10057613 | 125001942 | 3 Street Name | Locality3 | Town3 |  | XX12 XSB | [NAME] | [NAME] | [NAME] | Mr B [NAME]
400002397 | 10074366 | 125001965 | 4 Street Name | Locality4 | Town4 |  | XX12 XSB | [NAME] | Mr Campbell
400002421 | 10091119 | 125001988 | 5 Street Name | Locality5 | Town5 |  | XX12 XSB | [NAME]
400002445 | 10107872 | 125002011 | 6 Street Name | Locality6 | Town6 | Locality6 | XX12 XSB | Miss K Jordan | Mr B Jordan
400002661 | 10124625 | 125002034 | 15 Street Name | Locality15 | Town15 |  | XX12 XSB | ACHA
400002685 | 10141378 | 125002057 | 16 Street Name | Locality16 | Town15 |  | XX12 XSB | L Bennett | J [NAME] | T [NAME]
400002709 | 10158131 | 125002080 | 17 Street Name | Locality17 | Town15 |  | XX12 XSB | Mr T Kelly | Miss [NAME]
400002733 | 10174884 | 125002103 | 18 Street Name | Locality18 | Town15 |  | XX12 XSB | Mr [NAME] | Mrs [NAME] | [NAME] | [NAME]
400002757 | 10191637 | 125002126 | 19 Street Name | Locality19 | Town19 |  | XX12 XSB | [NAME] | Lara K 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 | Miss [NAME] | Mr [NAME] Jones | [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] | [NAME] | [NAME]
400002877 | 10275402 | 125002241 | 24 Street Name | Locality24 | Town23 | Locality7 | XX12 XSB | Sir [NAME] | [NAME]
400002901 | 10292155 | 125002264 | 25 Street Name | Locality25 | Town25 | Locality8 | XX12 XSB | Argyll & Bute Council Private Rentals
400002925 | 10308908 | 125002287 | 26 Street Name | Locality26 | Town26 |  | XX12 XSB | Miss [NAME] A Martin | [NAME] | [NAME]
400002949 | 10325661 | 125002310 | 27 Street Name | Locality27 | Town27 |  | XX12 XSB | Mr [NAME] Mellish | Mrs Veronica Mellish |  | [NAME]
400002973 | 10342414 | 125002333 | 28 Street Name | Locality28 | Town28 |  | XX12 XSB | Mr [NAME] J Lawrence | [NAME] | [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 | [NAME] | Mr Rhys A H Jones | Mia S Jones | [NAME]
400003069 | 10409426 | 125002425 | 32 Street Name | Locality32 | Town32 |  | XX12 XSB | Miss [NAME] | Mr [NAME] | [NAME] | [NAME]