Hi All,
I have a dataset in the following format
-------WholesaleKP RepairsKP
1999Q1 29,935,196 2,753,918
1999Q2 28,822,636 2,661,801
1999Q3 27,588,453 2,668,333
1999Q4 30,280,338 2,774,898
2000Q1 30,803,697 2,903,654
2000Q2 29,384,567 2,986,720
2000Q3 27,896,545 3,030,622
2000Q4 30,642,902 3,034,591
I would like to organise as
WholesaleKP
---------------Q1______ Q2
1999
2000
RepairsKP
---------------Q1______ Q2
1999
2000
I am using office 2007
Thanks
I have a dataset in the following format
-------WholesaleKP RepairsKP
1999Q1 29,935,196 2,753,918
1999Q2 28,822,636 2,661,801
1999Q3 27,588,453 2,668,333
1999Q4 30,280,338 2,774,898
2000Q1 30,803,697 2,903,654
2000Q2 29,384,567 2,986,720
2000Q3 27,896,545 3,030,622
2000Q4 30,642,902 3,034,591
I would like to organise as
WholesaleKP
---------------Q1______ Q2
1999
2000
RepairsKP
---------------Q1______ Q2
1999
2000
I am using office 2007
Thanks