SPSS question

I dont know if this is the best place to put this, but it is worth a shot:

I have been working on something in that has 8 columns (1-8) for my independent variable and I want to do an ANOVA with these 8 levels.

From what I have learned, to do an ANOVA (one way), you need a grouping variable, so that means having 2 columns; one for the grouping variable (in this case, 1-8) which is called "factor", and one for the dependent variable, which is called "dependent" in the program.

So at first I didn't mind rearranging my 8 columns into a grouping variable column and score column, but now that I have over 100 entries for each, it gets a little time consuming.

I was wondering if there was a way to either group the 8 columns w/o moving them, or if there is a feature that can put the 8 into the designated 2 columns.

Thanks!

 

i think we are off in the format. This is what I have now:

Treatment1 Treatment2 Treatment3 Treatment4 (all the way to 8)
6 4 5 1
6 6 7 2
5 3 2 3
2 9 1 4
3 8 0 5
1 11 12 6

(a 8x100= 8 columns, 100 rows)

and to do an ANOVA, I need it in this format:

Treatment Score
1 1
1 2
1 3
1 4
1 5
2 6
2 7
2 8
2 9
2 1
3 9
3 8
3 7
3 6
3 5

(a 2x800= 2 columns, 800 rows)

is there a way I can switch the formats besides doing it by manually??

edit- the tables are a little messed up, but its ok

 

actually i got it now. apparently there is a feature in DATA that says Restructure, so that helped out :-D