i need help with some data manipulation. i have a data set that looks like this:

1 11 1 12 2 21 2 22 2 23 2 24 3 31 4 41 4 42 4 43

i need to manipulate it so it looks like this:

1 11 12 . . 2 21 22 23 24 3 31 . . . 4 41 42 43 .

i'm using SPSS for Windows 6.1. i need either something similar to SAS first.var and last.var or some series of commands to get what i need. (or maybe a way to save the frequencies and then use match files to loop only as many times as there are cases of that type. i used to do this in SAS and then save it as a text file, but i no longer have access to SAS.)

thanks, mark Roxanne Klassen