Spreadsheet: 199944d1355369131-transposing-data-from-accounting-system-test-report
Sheet: Current Output

 | Cust A |  | Acct | 136790 | 136791
 |  |  | Name | Cust A | Cust A
 |  |  | Invoice | SIN1414 | SIN1413
 |  |  | O/S Base | 1014.36 | 1014.36
 |  |  | Curr | MYR | MYR
 |  |  | O/S Curr | 1250 | 1250
 |  |  | [NAME] | [EMAIL] | [EMAIL]
 | If | 89.69 | Acct | 100101 | 101319 | 101319 | 101598 | 103298 | 103372 | 103372 | 103372 | 103372 | 103372 | 103372 | 103372 | 103372 | 103372 | 103372 | 103372 | 103372 | 103372 | 103372 | 103391 | 103868 | 103936 | 104295 | 105032 | 105195 | 105200 | 105791 | 105791 | 105791 | 105882 | 107484 | 111104 | 111312 | 111312 | 111312 | 112211 | 112610
 |  |  | Name | Cust C | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D | Cust D
 |  |  | Invoice | SIN133155 | SIN139758 | SIN141726 | SIN140942 | SIN138674 | SIN078455 | SIN081404 | SIN102992 | SIN110620 | SIN121222 | SIN127285 | SIN129011 | [NAME] | SIN132907 | SIN134842 | SIN136589 | SIN138584 | SIN139547 | [NAME] | SIN136384 | SIN143137 | SIN133397 | SIN141806 | SIN141787 | SIN139511 | SIN142853 | SIN138889 | SIN139971 | [NAME] | SIN085630 | SIN098982 | SIN141916 | SIN138143 | SIN140285 | SIN141988 | [NAME] | SIN143227
 |  |  | O/S Base | 314.65 | 342.11 | 310.52 | 48.89 | 967.3 | 23.33 | 26.17 | 31.04 | 22.72 | 19.27 | 23.13 | 16.64 | 17.65 | 5.68 | 20.9 | 12.38 | 11.56 | 16.03 | 17.85 | 54.34 | 138 | 68.27 | 205.66 | 126.44 | 1055.49 | 108.74 | 696.26 | 133.96 | 130.47 | 176.25 | 70.5 | 46.42 | 270.74 | 99.65 | 284.1 | 62.63 | 258
 |  |  | Curr | MYR | MYR | MYR | MYR | MYR | MYR | MYR | MYR | MYR | MYR | MYR | MYR | MYR | EUR | EUR | EUR | EUR | EUR | EUR | EUR | GBP | GBP | EUR | GBP | GBP | GBP | EUR | EUR | EUR | GBP | GBP | EUR | GBP | GBP | GBP | GBP | GBP
 |  |  | O/S Curr | 314.65 | 342.11 | 310.52 | 48.89 | 1192 | 28.75 | 32.25 | 38.25 | 28 | 23.75 | 28.5 | 20.5 | 21.75 | 7 | 25.75 | 15.25 | 14.25 | 19.75 | 22 | 66.96 | 138 | 68.27 | 253.43 | 126.44 | 1055.49 | 108.74 | 858 | 165.08 | 160.78 | 176.25 | 70.5 | 57.2 | 270.74 | 99.65 | 284.1 | 62.63 | 258
 |  |  | [NAME] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
 | If | 97.77 | Acct | 113416 | 114188 | 114497 | 117509 | 118797 | 118797 | 118797 | 118797 | 118797 | 118797 | 118797 | 118797 | 119840 | 119840 | 121226 | 121226 | 121908 | 122795 | 124818 | 124818 | 126670 | 126677 | 128874 | 128874 | 129027 | 129027 | 129184 | 129824 | 129836 | 132238 | 132285 | 134020 | 134020 | 134667 | 134667 | 136373 | 136672 | 136784
 |  |  | Name | Cust E | Cust F | Cust E | Cust F | Cust E | Cust F | Cust E | Cust F | Cust E | Cust F | Cust E | Cust F | Cust E | Cust F | Cust E | Cust F | Cust E | Cust F | Cust E | Cust F | Cust E | Cust F | Cust E | Cust F | Cust E | Cust F | Cust E | Cust F | Cust E | Cust F | Cust E | Cust F | Cust E | Cust F | Cust E | Cust F | Cust E | Cust F
 |  |  | Invoice | SIN140244 | SIN136689 | SIN137156 | SIN127636 | SIN102667 | SIN105062 | SIN109138 | SIN110938 | SIN137599 | SIN139120 | SIN140309 | SIN142549 | SIN113594 | SIN131510 | SIN115207 | SIN135901 | [NAME] | SIN141530 | SIN138381 | SIN139744 | [NAME] | SIN142045 | SIN119662 | SIN134230 | SIN130756 | SIN140766 | SIN131081 | SIN129053 | SIN142785 | SIN142165 | [NAME] | SIN133865 | SIN142583 | SIN135868 | SIN140866 | SIN138814 | SIN141215 | SIN141482
 |  |  | O/S Base | 77.19 | 917.8 | 1011.93 | 1011.12 | 49.48 | 49.26 | 46.93 | 50.63 | 41.26 | 48.69 | 70.32 | 88.25 | 138 | 498 | 64.04 | 64.07 | 29.38 | 139.98 | 129.31 | 131.76 | 28.4 | 43.01 | 48.69 | 45.11 | 65.45 | 77.93 | 139.98 | 568.04 | 42.17 | 139.98 | 442.09 | 68.64 | 62.16 | 46.16 | 53.93 | 1010.31 | 1020 | 89.69
 |  |  | Curr | GBP | EUR | EUR | EUR | EUR | EUR | EUR | EUR | EUR | EUR | EUR | EUR | GBP | GBP | GBP | GBP | GBP | EUR | GBP | GBP | EUR | EUR | EUR | EUR | GBP | GBP | EUR | EUR | EUR | EUR | USD | GBP | GBP | EUR | EUR | EUR | GBP | USD
 |  |  | O/S Curr | 77.19 | 1131 | 1247 | 1246 | 60.98 | 60.7 | 57.83 | 62.39 | 50.84 | 60 | 86.65 | 108.75 | 138 | 498 | 64.04 | 64.07 | 29.38 | 172.5 | 129.31 | 131.76 | 35 | 53 | 60 | 55.59 | 65.45 | 77.93 | 172.5 | 700 | 51.97 | 172.5 | 708.54 | 68.64 | 62.16 | 56.88 | 66.46 | 1245 | 1020 | 143.75
 |  |  | [NAME] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]