Hi, anyone good at editing data? I've got a data set in Excel like this:
row1: M1 M2 M3 M4 M5 M6....M64
row2: A B C B C B ...A

how could I make the data like this in SPSS:
column1 column2
M1 A
M2 B
M3 C
M4 B
M5 C
. .
. .
. .
. .
M64

I didn't find any options I can choose when 'read text' in SPSS. could anybody give me a clue?

in excel: copy, paste special, transpose

Hi pprabit,

I am afraid that I do not know the answer to your question.

Would you mind if I ask you a question regarding a related issue: are you able to do all the statistical calculations on excel or does one really need SPSS?

I have some experience using excel, but do not know SPSS. What are your views?

Yes, SPSS is a proper stats package whereas Excel is basically a spreadsheet utility with a few stats thrown in. Most unis will run SPSS courses - it's not that difficult when you know how to set up your data and will be well worth the effort.

Thanks Ann,

that information is useful.

So you are using SPSS?

Thank you very much, ras31.

And thank you, Ann, that was what I would say.

And I usually have the original data in Excel, with all the variables, notes, etc, and copy those essentials to SPSS to run the stats. well, it's just my own personal way, as i'm not used to find a variable from a long list in SPSS