I have a table of data structured as follows
field1 field2 field3 field4 tom1 tom2 tom3 tom4
.5 0 .65 .72 .7 .8 9 1.1
I want the display to be like
Field Tom
1 .5 .7
2 0 .8
3 .65 9
4 .72 1.1
Is there a simple formatting tool to do this? I have tried crosstab and Mailing labels but to no avail. The data is in the table exactly as listed above. tom* and field* are in the same field
field1 field2 field3 field4 tom1 tom2 tom3 tom4
.5 0 .65 .72 .7 .8 9 1.1
I want the display to be like
Field Tom
1 .5 .7
2 0 .8
3 .65 9
4 .72 1.1
Is there a simple formatting tool to do this? I have tried crosstab and Mailing labels but to no avail. The data is in the table exactly as listed above. tom* and field* are in the same field