Rearreanging Data (Cool Problem)

[Eugenio Grant]

Hi I think this is a nice problem. actually I have 20 columns.



How can I go from this .



V1     V2     V3

-----------------

1        2        3

2         3        .

1         2        .

3        .        .

1        .         .



To this .



NewV1     NewV2     NewV3

-------------------------------------

1        2        3

.         2        3

1        2         .

.         .         3.

1        .         .

[Beadle, ViAnn]

Why do you want to do this?

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Eugenio Grant
Sent: Tuesday, January 30, 2007 4:12 PM
To: [hidden email]
Subject: Rearreanging Data (Cool Problem)

Hi I think this is a nice problem. actually I have 20 columns.



How can I go from this .



V1     V2     V3

-----------------

1        2        3

2         3        .

1         2        .

3        .        .

1        .         .



To this .



NewV1     NewV2     NewV3

-------------------------------------

1        2        3

.         2        3

1        2         .

.         .         3.

1        .         .