I have the following problem:

My data look's like this:
X Y
1 1
1 1.23
1 0.99
2 1.87
2 2.03
3 3
3 3.12
3 2.80

and I need the data in the following format (for statistics on rows!)
1 1 1.23 0.99
2 1.87 2.03
3 3 3.12 2.80

What must I do ???

Thx

%W=%H;
get col(A) -e npt;
nn=col(A)[1];
win -t D;
col(A)[1]=nn;
col(B)[1]=%W_B[1];
mm=1; kk=0;
loop(ii,2,npt) {
if(%W_A[ii]==nn) {
kk++; wo -v B$(kk);
col(B$(kk))[mm]=%W_B[ii];
} else {
nn=%W_A[ii];
mm++; kk=0;
set %H -er mm;
col(A)[mm]=nn;
col(B)[mm]=%W_B[ii];
};
};

thanks for your answer! The values for each row are variable (1 to ? (I think not more than 10)).

Ciao,

How many possible values for each row? You show a max of 3, can there be more? Is it fixed or does it vary? If it's always 3 then you can use this script.

//Move data from rows to columns C & D
loop(ii, 1, wks.nrows) {

end=list($(ii)+1, Data1_A); end=;
col(C)[$(end)-3]=col(Y)[$(end)-1];
col(D)[$(end)-3]=col(Y)[$(end)];

};

Otherwise it will be a little different.

Craig