Spreadsheet: 823645d1680074190-group-4-data-sets-into-one-boooook
Sheet: Sheet2

ID | Surname | First Name | CODE | Value 1 | ID | Surname | First Name | CODE | Value 2 | ID | Surname | First Name | CODE | Value 3 | ID | Surname | First Name | CODE | Value 4 |  | ID | Surname | First Name | CODE | Value 1 | Value 2 | Value 3 | Value 4 |  | Version 1
111 | aaa | aaa | xxx | 70 | 111 | aaa | aaa | xxx | 1 | 555 | eee | eee | xxx | 5 | 555 | eee | eee | yyy | 5 |  | 111 | aaa | aaa | xxx | 70 | 1 | 0 | 0 |  |  | aaa | aaa | xxx
222 | bbb | bbb | ooo | 48 | 222 | bbb | bbb | xxx | 2 |  |  |  |  |  | 111 | aaa | aaa | xxx | 70 |  | 111 | aaa | aaa | xxx | 0 | 0 | 0 | 70 |  | 111 | aaa | aaa | xxx
333 | [NAME] | [NAME] | yyy | 59 | 333 | [NAME] | [NAME] | yyy | 3 |  |  |  |  |  |  |  |  |  |  |  | 222 | bbb | bbb | ooo | 48 | 2 | 0 | 0 |  | 111 | aaa | aaa | xxx
444 | ddd | eee | ggg | 84 | 444 | ddd | ddd | yyy | 4 |  |  |  |  |  |  |  |  |  |  |  | 333 | [NAME] | [NAME] | yyy | 59 | 3 | 0 | 0 |  | 222 | bbb | bbb | ooo
555 | eee | eee | hhh | 86 | 555 | eee | eee | abc | 5 |  |  |  |  |  |  |  |  |  |  |  | 444 | ddd | eee | ggg | 84 | 4 | 0 | 0 |  | 222 | bbb | bbb | xxx
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | hhh | 86 | 5 | 0 | 0 |  | 333 | [NAME] | [NAME] | yyy
RAW DATA 1 |  |  |  |  | RAW DATA 2 |  |  |  |  | RAW DATA 3 |  |  |  |  | RAW DATA 4 |  |  |  |  |  | 222 | bbb | bbb | xxx | 0 | 2 | 0 | 0 |  | 333 | [NAME] | [NAME] | yyy
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 444 | ddd | ddd | yyy | 0 | 4 | 0 | 0 |  | 444 | ddd | eee | ggg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | abc | 0 | 5 | 0 | 0 |  | 444 | ddd | ddd | yyy
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | xxx | 0 | 0 | 5 | 0 |  | 555 | eee | eee | hhh
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | yyy | 0 | 0 | 0 | 5 |  | 555 | eee | eee | abc
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | xxx
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Desired Results |  |  |  |  |  |  |  |  | 555 | eee | eee | yyy
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Version 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | aaa | aaa | xxx
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 222 | bbb | bbb | ooo
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 222 | bbb | bbb | xxx
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 333 | [NAME] | [NAME] | yyy
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 444 | ddd | eee | ggg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 444 | ddd | ddd | yyy
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | hhh
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | abc
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | xxx
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | yyy