Spreadsheet: 93638d1293295004-transpose-different-sets-of-data-in-rows-to-columns-example
Sheet: Sheet1

3218105Q IX Equity
Date | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00
PX_VOLUME | 305 | 1285 | 7089 | 996 | 5238 | 4400
TURNOVER | 5523.97 | 24209.2 | 96566.07 | 15510.4 | 73593.54 | 68219.07
EQY_WEIGHTED_AVG_PX | 18.1114 | 18.8398 | 13.5769 | 15.5727 | 14.0499 | 15.5043
T4I GR Equity
Date | 2011-12-01 00:00:00 | 2012-05-31 00:00:00 | 2012-11-01 00:00:00 | 2012-11-29 00:00:00 | 2013-01-01 00:00:00 | 2013-05-30 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-31 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-01-30 00:00:00 | 2014-02-27 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-07-31 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-10-30 00:00:00 | 2014-12-01 00:00:00
PX_VOLUME | 22 | 130 | 30 | 250 | 1950 | 100 | 10601 | 6000 | 700 | 645 | 660 | 3551 | 1605 | 2063 | 340 | 1650 | 250 | 1770 | 1940 | 2380 | 2960 | 3320
TURNOVER | 526.79 | 2117.7 | 385.65 | 2907 | 22266 | 1442 | 167355.7 | 98460 | 12984.98 | 12154.96 | 13100.4 | 73685.19 | 32729.85 | 45244.6 | 7766.52 | 35344.35 | 5515 | 42570.35 | 43040.75 | 58912.8 | 78169.45 | 96951.91
EQY_WEIGHTED_AVG_PX | 23.945 | 16.19 | 12.68 | 10.83 | 11.44 | 14.42 | 15.8107 | 16.1 | 18.6 | 18.73 | 19.12 | 20.87 | 21.44 | 22.865 | 22.55 | 20.54 | 22.15 | 21.63 | 22.8718 | 25.3 | 29.3109 | 27.4006
TNET BB Equity
Date | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-11-29 00:00:00 | 2013-01-01 00:00:00 | 2013-01-31 00:00:00 | 2013-02-28 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-05-30 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-10-31 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-01-30 00:00:00 | 2014-02-27 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-07-31 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-10-30 00:00:00 | 2014-12-01 00:00:00
PX_VOLUME | 8498950 | 3492892 | 5517747 | 6502404 | 7713291 | 3841542 | 4202744 | 6067796 | 6414248 | 4576659 | 4782832 | 9003578 | 5825077 | 4007436 | 4173093 | 5882644 | 7906723 | 7037537 | 5926380 | 5093059 | 3857844 | 5902173 | 5393646 | 6993880 | 5066234 | 4042040 | 4718301 | 5507314 | 6467861 | 5552308 | 6622960 | 6273777 | 5682954 | 5063014 | 5652063 | 6473818 | 5494207
TURNOVER | 185266400 | 68240000 | 100757700 | 107267500 | 106580000 | 56379650 | 67045140 | 92467540 | 88370640 | 69062700 | 71646200 | 110976000 | 66621650 | 46472470 | 52410420 | 77938680 | 105911000 | 94127000 | 84506070 | 83543520 | 61252150 | 99984850 | 95572250 | 128588500 | 93930810 | 79528070 | 97507560 | 116609300 | 141818300 | 130331800 | 138879900 | 138496800 | 133533600 | 115142400 | 137488700 | 172571800 | 159701000
EQY_WEIGHTED_AVG_PX | 19.6582 | 19.8693 | 18.4238 | 14.1172 | 13.9201 | 15.579 | 16.1288 | 14.1512 | 13.877 | 15.6467 | 14.2458 | 12.0818 | 11.5544 | 12.1466 | 12.4127 | 13.7816 | 12.6683 | 14.8242 | 13.9893 | 15.0412 | 16.2224 | 16.5794 | 17.9966 | 18.4465 | 18.1 | 19.8962 | 20.7755 | 21.7359 | 22.2383 | 22.8324 | 21.1977 | 21.5445 | 21.997 | 23.3937 | 24.4982 | 29.4655 | 27.8323
TNET BQ Equity
Date | 2014-01-01 00:00:00 | 2014-01-30 00:00:00 | 2014-02-27 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-07-31 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-10-30 00:00:00 | 2014-12-01 00:00:00
PX_VOLUME | 7581 | 16342 | 16564 | 12777 | 22902 | 42104 | 22410 | 54233 | 56389 | 53428 | 89441 | 125100
TURNOVER | 147303.2 | 335548.9 | 343035.1 | 279835.9 | 521576.2 | 882567.9 | 488707.1 | 1252144 | 1268788 | 1299936 | 2424037 | 3610668
EQY_WEIGHTED_AVG_PX | 19.6822 | 20.92 | 21.7661 | 22.0866 | 22.8893 | 20.7508 | 21.4698 | 21.9391 | 23.302 | 24.4273 | 29.3517 | 27.781
TNET EB Equity
Date | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-05-30 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-10-31 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-01-30 00:00:00 | 2014-02-27 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-07-31 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-10-30 00:00:00 | 2014-12-01 00:00:00
PX_VOLUME | 12200 | 32925 | 26066 | 10992 | 4799 | 13489 | 21591 | 44575 | 69975 | 50165 | 49858 | 56702 | 92607 | 106718 | 148539 | 174503 | 214793 | 142141 | 128819 | 272609 | 419222
TURNOVER | 156210.4 | 432937.7 | 368362.2 | 158192.2 | 74535.89 | 223478.9 | 376306.7 | 811545.7 | 1287657 | 979408.9 | 1025588 | 1166692 | 2031617 | 2456768 | 3103070 | 3811123 | 5006189 | 3203758 | 3112169 | 7288674 | 12074930
EQY_WEIGHTED_AVG_PX | 12.6112 | 14.7806 | 13.7925 | 15.0532 | 16.2942 | 16.6235 | 17.9918 | 18.3337 | 18.0745 | 19.6744 | 20.7327 | 21.7602 | 22.2481 | 22.7755 | 21.1995 | 21.5417 | 21.9641 | 23.3149 | 24.5313 | 29.4819 | 27.8007