Spreadsheet: 68691d1269280773-how-do-i-populate-one-sheet-with-data-filtered-from-another-projectlogexample
Sheet: project log

Locales | Project | DATA 1 | DATA 2 | DATA 3 | DATA 4 | DATA 5 | DATA 6 | DATA 7 | DATA 8 | DATA 9 | DATA 10 | DATA 11 | DATA 12 | DATA 13 | DATA 14 | DATA 15 | DATA 16 | Comments
ES | project a | 12345 | C |  | 001 | 0200 |  | 1921 | 0 | 546 | 27 | 0 | 1238 | 110 | 0 | 0 | 15
IT | project a | 12345 | E |  | 001 | 0200 |  | 1921 | 376 | 211 | 12 | 58 | 1158 | 106 | 0 | 0 | 15
SZH | project a | 12345 | F |  | 001 | 0200 |  | 1921 | 376 | 210 | 13 | 58 | 1158 | 106 | 0 | 0 | 15
DE | project a | 12345 | G |  | 001 | 0200 |  | 1921 | 477 | 110 | 12 | 58 | 1158 | 106 | 0 | 0 | 15
FR | project a | 12345 | G |  | 001 | 0200 |  | 1921 | 417 | 170 | 12 | 58 | 1158 | 106 | 0 | 0 | 15
JA | project a | 12345 | H |  | 001 | 0200 |  | 1921 | 376 | 210 | 13 | 58 | 1158 | 106 | 0 | 0 | 15
FRC | project b | 12346 | B | [NAME] doe | 013 | 300 |  | 389 | 0 | 53 | 7 | 11 | 200 | 118 | 0 | 0 | 1
FRC | project c | 12347 | D | jane doe | 016 | 0800 |  | 847 | 2 | 20 | 11 | 9 | 790 | 15 | 0 | 0 | 0
ES | project d | 12348 | C | [NAME] doe | 001 | 0200 | ALL | 599 | 0 | 290 | 4 | 0 | 300 | 5 | 0 | 0 | 7
FRC | project d | 12348 | E | [NAME] doe | 001 | 0200 | ALL | 599 | 12 | 275 | 0 | 0 | 307 | 5 | 0 | 0 | 7
SZH | project d | 12348 | F | [NAME] doe | 001 | 0200 | ALL | 599 | 12 | 278 | 6 | 0 | 298 | 5 | 0 | 0 | 7
DE | project d | 12348 | G | [NAME] doe | 001 | 0200 | ALL | 599 | 16 | 274 | 4 | 2 | 298 | 5 | 0 | 0 | 7
FR | project d | 12348 | G | [NAME] doe | 001 | 0200 | ALL | 599 | 16 | 274 | 4 | 2 | 298 | 5 | 0 | 0 | 7
JA | project d | 12348 | H | [NAME] doe | 001 | 0200 | ALL | 599 | 16 | 274 | 4 | 0 | 300 | 5 | 0 | 0 | 7
IT | project e batch1 | 12349 | A | [NAME] doe | 001 | 0200 | ALL | 2052 | 0 | 102 | 0 | 0 | 1950 | 0 | 0 | 0 | 0
ES | project e batch1 | 12349 | C | [NAME] doe | 001 | 0200 | ALL | 2052 | 0 | 81 | 1 | 0 | 1960 | 10 | 0 | 0 | 0
FRC | project e batch1 | 12349 | D | [NAME] doe | 001 | 0200 | ALL | 2052 | 0 | 81 | 1 | 0 | 1960 | 10 | 0 | 0 | 0
SZH | project e batch1 | 12349 | F | [NAME] doe | 001 | 0200 | ALL | 2052 | 0 | 82 | 0 | 0 | 1960 | 10 | 0 | 0 | 0
DE | project e batch1 | 12349 | G | [NAME] doe | 001 | 0200 | ALL | 2052 | 0 | 82 | 0 | 0 | 1960 | 10 | 0 | 0 | 0
FR | project e batch1 | 12349 | G | [NAME] doe | 001 | 0200 | ALL | 2052 | 0 | 82 | 0 | 0 | 1960 | 10 | 0 | 0 | 0
JA | project e batch1 | 12349 | H | [NAME] doe | 001 | 0200 | ALL | 2052 | 0 | 82 | 0 | 0 | 1960 | 10 | 0 | 0 | 0
IT | project e batch2 | 12350 | A | [NAME] doe | 001 | 0200 | ALL | 2120 | 0 | 102 | 0 | 0 | 2018 | 0 | 0 | 0 | 0
ES | project e batch2 | 12350 | C | [NAME] doe | 001 | 0200 | ALL | 2120 | 0 | 89 | 0 | 0 | 2031 | 0 | 0 | 0 | 0
FRC | project e batch2 | 12350 | D | [NAME] doe | 001 | 0200 | ALL | 2120 | 0 | 89 | 3 | 0 | 2028 | 0 | 0 | 0 | 0
SZH | project e batch2 | 12350 | F | [NAME] doe | 001 | 0200 | ALL | 2120 | 0 | 92 | 0 | 0 | 2028 | 0 | 0 | 0 | 0
DE | project e batch2 | 12350 | G | [NAME] doe | 001 | 0200 | ALL | 2120 | 0 | 92 | 0 | 0 | 2028 | 0 | 0 | 0 | 0
FR | project e batch2 | 12350 | G | [NAME] doe | 001 | 0200 | ALL | 2120 | 0 | 92 | 0 | 0 | 2028 | 0 | 0 | 0 | 0
JA | project e batch2 | 12350 | H | [NAME] doe | 001 | 0200 | ALL | 2120 | 0 | 92 | 0 | 0 | 2028 | 0 | 0 | 0 | 0
IT | project e batch3 | 12351 | A | [NAME] doe | 001 | 0200 | ALL | 2062 | 0 | 91 | 0 | 0 | 1971 | 0 | 0 | 0 | 0
ES | project e batch3 | 12351 | C | [NAME] doe | 001 | 0200 | ALL | 2062 | 0 | 71 | 0 | 0 | 1981 | 10 | 0 | 0 | 0
FRC | project e batch3 | 12351 | D | [NAME] doe | 001 | 0200 | ALL | 2062 | 0 | 71 | 0 | 0 | 1981 | 10 | 0 | 0 | 0
SZH | project e batch3 | 12351 | F | [NAME] doe | 001 | 0200 | ALL | 2062 | 0 | 71 | 0 | 0 | 1981 | 10 | 0 | 0 | 0
DE | project e batch3 | 12351 | G | [NAME] doe | 001 | 0200 | ALL | 2062 | 0 | 71 | 0 | 0 | 1981 | 10 | 0 | 0 | 0
FR | project e batch3 | 12351 | G | [NAME] doe | 001 | 0200 | ALL | 2062 | 0 | 71 | 0 | 0 | 1981 | 10 | 0 | 0 | 0
JA | project e batch3 | 12351 | H | [NAME] doe | 001 | 0200 | ALL | 2062 | 0 | 71 | 0 | 0 | 1981 | 10 | 0 | 0 | 0
DE | project f | 12352 | G | [NAME] doe | 005 | 0300 |  | 1476 | 228 | 768 | 183 | 83 | 203 | 11 | 0 | 0 | 0
SZH | project f | 12353 | F | [NAME] doe | 005 | 0300 |  | 1476 | 146 | 725 | 308 | 83 | 203 | 11 | 0 | 0 | 0
FR | project f | 12354 | G | [NAME] doe | 005 | 0300 |  | 1476 | 176 | 856 | 147 | 83 | 203 | 11 | 0 | 0 | 0
IT | project f | 12355 | E | [NAME] doe | 005 | 0300 |  | 1476 | 146 | 895 | 106 | 83 | 235 | 11 | 0 | 0 | 0
JA | project f | 12356 | H | [NAME] doe | 005 | 0300 |  | 1476 | 97 | 776 | 306 | 83 | 203 | 11 | 0 | 0 | 0