Quasi Transpose / Stacking Columns
Appreciate any tips on doing the following matrix change:
Original Matrix
Date Series 1 Series 2 Series 3
1/1/2005 23 45 99
1/2/2005 24 46 100
1/3/2005 20 40 101
1/4/2005 22 40 99
1/5/2005 25 46 98
New Matrix
Date Series Data
1/1/2005 Series 1 23
1/2/2005 Series 1 24
1/3/2005 Series 1 20
1/4/2005 Series 1 22
1/5/2005 Series 1 25
1/1/2005 Series 2 45
1/2/2005 Series 2 46
1/3/2005 Series 2 40
1/4/2005 Series 2 40
1/5/2005 Series 2 46
1/1/2005 Series 3 99
1/2/2005 Series 3 100
1/3/2005 Series 3 101
1/4/2005 Series 3 99
1/5/2005 Series 3 98
Thanks in advance. Mike
|