I am modifiying an existing crosstab that originally displayed dates as row names and test names as columns. I changed the rows to be the test names and the columns to be the dates. I used the crosstab expert to change these which seemed pretty simple. It worked exept it has added and additional number of rows for however many test names there are. Why did it do that and how do I fix? Here is an example. This particular example has 4 test names so it through in 4 extra rows with a 1, 2, 3 and 4. 😔
11/28/12 12/3/12
Test Name 1 6.0 6.1
Test Name 2 4.4 4.4
1
2
3
4
Test Name 3 9 9
Test Name 4 .012 .012