Spreadsheet: 682687d1592255688-need-help-moving-data-from-rows-to-columns-sorta-transposing-but-sorta-not-transposing-slighhtly-larger-example
Sheet: Sheet1

Code | Level | Cut | Variable | n Orgs | n Incumbents | 10th Percentile | 25th Percentile | Mean | Median | 75th Percentile | 90th Percentile
123 | Accountant | National | Base Salary | 291 | 11039 | 161183.322362424 | 190962.4 | 233649.3952739946 | 221300 | 258017.5134420095 | 316657.6
123 | Accountant | National | TCC | 298 | 11454 | 180000 | 207754.1674999997 | 260725.0796480942 | 241085.45 | 299894.082620473 | 358367.2650000001
123 | Accountant | National | Extra 1 | 222 | 7403 | 3000 | 3874.315 | 4945.947221171946 | 4834.84 | 5808.302777777775 | 6939.79
123 | Accountant | National | Extra 2 | 94 | 3147 | 254084.4195744682 | 344237.73 | 496138.6770142969 | 460954.36 | 608322.51 | 783249.2
123 | Accountant | National | Extra 3 | 62 | 1756 | 2 | 4 | 13.77987357817875 | 11 | 21 | 31
123 | Accountant | Seattle | Base Salary | 146 | 4273 | 160309.808 | 187886.4 | 235317.7461276059 | 220000 | 260000 | 319351.208
123 | Accountant | Seattle | TCC | 147 | 4376 | 173707.04 | 201031.9875 | 251510.5174320621 | 232076.57 | 279510.2725 | 343823.2776643755
123 | Accountant | Seattle | Extra 1 | 96 | 2710 | 2962.792133624682 | 3810.36673787685 | 4877.987182154392 | 4781.03571428571 | 5653.425 | 6870.815952380949
123 | Accountant | Seattle | Extra 2 | 33 | 905 | 262026.4 | 340000 | 455269.6377250496 | 436822.818181818 | 552406.55 | 667793.7860000001
123 | Accountant | Seattle | Extra 3 | 32 | 864 | 2 | 5 | 14.34534817354311 | 12 | 21.638356165 | 31
123 | Accountant | Dallas | Base Salary | 139 | 6668 | 162227.212 | 194256.4372297295 | 232671.8388786647 | 222039.6204216515 | 256779.6741666665 | 314581.094
123 | Accountant | Dallas | TCC | 145 | 6980 | 182714.94 | 212283.7896254887 | 266629.7755049645 | 248320.975 | 313391.1601470588 | 365395.7070000001
123 | Accountant | Dallas | Extra 1 | 122 | 4636 | 3052.73 | 3912.38392011825 | 4985.209806236132 | 4861.41 | 5878 | 6956.91
123 | Accountant | Dallas | Extra 2 | 60 | 2228 | 253363.737 | 347973.7575 | 514117.8053635391 | 474925.7455882355 | 643919.9863945578 | 822963.878
123 | Accountant | Dallas | Extra 3 | 29 | 868 | 2 | 4 | 13.47570685071178 | 11 | 21 | 30
123 | Accountant | New York | Base Salary | 98 | 3610 | 162244.5 | 195000 | 235689.275185523 | 225639.1 | 263521.5166666665 | 315810.14
123 | Accountant | New York | TCC | 103 | 3803 | 181029.826 | 209888.275 | 252923.2691096068 | 238078 | 282146.69 | 341025.34
123 | Accountant | New York | Extra 1 | 86 | 3201 | 2988.78 | 3846.7 | 4839.34968156485 | 4764.39 | 5624.42 | 6673.01
123 | Accountant | New York | Extra 2 | 29 | 1075 | 221374.0855555556 | 345988.9010714285 | 541763.5706306102 | 497404 | 695824.63 | 887823.7466666668
123 | Accountant | New York | Extra 3 | 26 | 464 | 1 | 4 | 14.43552196504488 | 12 | 23 | 32
123 | Accountant | Chicago | Base Salary | 82 | 3112 | 160000.005 | 193806.7425 | 234163.5934539529 | 225456.88 | 262360.9575 | 312202.4885133017
123 | Accountant | Chicago | TCC | 84 | 3267 | 180000.006 | 209329.52 | 250754.5348938963 | 237488.285586895 | 279415.965 | 332568.6000000001
123 | Accountant | Chicago | Extra 1 | 71 | 2750 | 3007.938 | 3836.745145420873 | 4802.141364632892 | 4728.092143643365 | 5574.065000000001 | 6578.584999999999
123 | Accountant | Chicago | Extra 2 | 22 | 802 | 205217.1911111111 | 319025.7483333332 | 477256.1281147272 | 458019.2692105265 | 602822.25 | 750674.0769999998
123 | Accountant | Chicago | Extra 3 | 23 | 401 | 2 | 4.50684931506849 | 15.09995559047587 | 13 | 23 | 32