Spreadsheet: 819235d1677330930-formula-to-move-from-selected-column-cells-to-row-cells-based-on-criteria-sample2-2-
Sheet: Sheet1

 | AS IS
 |  |  | ARGENTINA | ARGENTINA | ARGENTINA | ARGENTINA | ARGENTINA | BRAZIL | BRAZIL | BRAZIL | BRAZIL | BRAZIL | MALAYSIA | MALAYSIA | MALAYSIA | MALAYSIA | MALAYSIA | USA | USA | USA | USA | USA
 | SKU |  | W1 | [NAME] | W3 | W4 | TTL | W1 | [NAME] | W3 | W4 | TTL | W1 | [NAME] | W3 | W4 | TTL | W1 | [NAME] | W3 | W4 | TTL
 | DH1U6A050 |  | 1338 | 1673 | 2008 | 1673 | 6692 | 798 | 665 | 798 | 400 | 2661 | 256 | 214 | 171 | 213 | 854 | 290 | 363 | 363 | 434 | 1450
 | DH1RV1050 |  | 1346 | 1682 | 2019 | 1682 | 6729 | 874 | 728 | 874 | 436 | 2912 | 131 | 109 | 87 | 109 | 436 | 365 | 456 | 456 | 546 | 1823
 | DH1VY3050 |  | 432 | 540 | 648 | 541 | 2161 | 213 | 178 | 213 | 106 | 710 | 91 | 76 | 61 | 75 | 303 | 74 | 93 | 93 | 110 | 370
 | DH1VY8050 |  | 249 | 312 | 374 | 312 | 1247 | 103 | 86 | 103 | 51 | 343 | 93 | 78 | 62 | 77 | 310 | 111 | 139 | 139 | 165 | 554
 | DH1U98050 |  | 351 | 439 | 526 | 438 | 1754 | 50 | 42 | 50 | 25 | 167 | 28 | 24 | 19 | 23 | 94 | 66 | 82 | 82 | 98 | 328
 | DH1U6B050 |  | 607 | 759 | 910 | 758 | 3034 | 1 | 1 | 0 | 0 | 2 | 2 | 2 | 1 | 1 | 6 | 1 | 1 | 1 | 0 | 3
 | DH1SV2000 |  | 204 | 255 | 305 | 254 | 1018 | 45 | 38 | 45 | 23 | 151 | 2 | 1 | 1 | 1 | 5 | 24 | 30 | 30 | 37 | 121
 | DH1VV5050 |  | 59 | 74 | 89 | 74 | 296 | 39 | 32 | 39 | 19 | 129 | 6 | 5 | 4 | 4 | 19 | 15 | 19 | 19 | 23 | 76
 | DH1VY2050 |  | 138 | 173 | 208 | 173 | 692 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 4 | 1 | 1 | 1 | 2 | 5
 | DH1U91050 |  | 108 | 135 | 162 | 136 | 541 | 29 | 25 | 29 | 15 | 98 | 9 | 8 | 6 | 7 | 30 | 11 | 14 | 14 | 18 | 57
 |  |  |  |  |  | data population moved based on country weekly forecast from i7:m16 to D33:H42 and same with the rest of the country
 | TO BE
 | SKU | ACCOUNT | W1 | [NAME] | W3 | W4 | TTL |  |  | SKU | ACCOUNT | W1 | [NAME] | W3 | W4 | TTL
 | DH1U6A050 | ARGENTINA | 1338 | 1673 | 2008 | 1673 | 6692
 | DH1RV1050 | ARGENTINA | 1346 | 1682 | 2019 | 1682 | 6729
 | DH1VY3050 | ARGENTINA | 432 | 540 | 648 | 541 | 2161
 | DH1VY8050 | ARGENTINA | 249 | 312 | 374 | 312 | 1247
 | DH1U98050 | ARGENTINA | 351 | 439 | 526 | 438 | 1754
 | DH1U6B050 | ARGENTINA | 607 | 759 | 910 | 758 | 3034
 | DH1SV2000 | ARGENTINA | 204 | 255 | 305 | 254 | 1018
 | DH1VV5050 | ARGENTINA | 59 | 74 | 89 | 74 | 296
 | DH1VY2050 | ARGENTINA | 138 | 173 | 208 | 173 | 692
 | DH1U91050 | ARGENTINA | 108 | 135 | 162 | 136 | 541
 | DH1U6A050 | BRAZIL | 798 | 665 | 798 | 400 | 2661
 | DH1RV1050 |  | 874 | 728 | 874 | 436 | 2912
 | DH1VY3050 |  | 213 | 178 | 213 | 106 | 710
 | DH1VY8050 |  | 103 | 86 | 103 | 51 | 343
 | DH1U98050 |  | 50 | 42 | 50 | 25 | 167
 | DH1U6B050 |  | 1 | 1 | 0 | 0 | 2
 | DH1SV2000 |  | 45 | 38 | 45 | 23 | 151
 | DH1VV5050 |  | 39 | 32 | 39 | 19 | 129
 | DH1VY2050 |  | 0 | 0 | 0 | 1 | 1
 | DH1U91050 |  | 29 | 25 | 29 | 15 | 98
 | DH1U6A050 | MALAYSIA | 256 | 214 | 171 | 213 | 854
 | DH1RV1050 |  | 131 | 109 | 87 | 109 | 436
 | DH1VY3050 |  | 91 | 76 | 61 | 75 | 303
 | DH1VY8050 |  | 93 | 78 | 62 | 77 | 310
 | DH1U98050 |  | 28 | 24 | 19 | 23 | 94
 | DH1U6B050 |  | 2 | 2 | 1 | 1 | 6
 | DH1SV2000 |  | 2 | 1 | 1 | 1 | 5
 | DH1VV5050 |  | 6 | 5 | 4 | 4 | 19
 | DH1VY2050 |  | 1 | 1 | 1 | 1 | 4
 | DH1U91050 |  | 9 | 8 | 6 | 7 | 30
 | DH1U6A050 | USA | 290 | 363 | 363 | 434 | 1450
 | DH1RV1050 |  | 365 | 456 | 456 | 546 | 1823
 | DH1VY3050 |  | 74 | 93 | 93 | 110 | 370
 | DH1VY8050 |  | 111 | 139 | 139 | 165 | 554
 | DH1U98050 |  | 66 | 82 | 82 | 98 | 328
 | DH1U6B050 |  | 1 | 1 | 1 | 0 | 3
 | DH1SV2000 |  | 24 | 30 | 30 | 37 | 121
 | DH1VV5050 |  | 15 | 19 | 19 | 23 | 76
 | DH1VY2050 |  | 1 | 1 | 1 | 2 | 5
 | DH1U91050 |  | 11 | 14 | 14 | 18 | 57