newprogram
Programmer
Hi, All,
I have the dataset like this:
the question is: how to insert m2 between m1 and m10,
insert m3 between m2 and m10
insert m4 between m3 and m10....
orinigal dataset:
m1 m15 m20 m26 m31 m37
m10 m16 m21 m27 m32 m38
m11 m17 m22 m28 m33 m39
m12 m18 m23 m29 m34 m4
m13 m19 m24 m3 m35 m40
m14 m2 m25 m30 m36 m41....
the final dataset should be like that:
m1 m7 m13 m19 m25 m31 m37 m43
m2 m8 m14 m20 m26 m32 m38 m44
m3 m9 m15 m21 m27 m33 m39 m45
m4 m10 m16 m22 m28 m34 m40 m46
m5 m11 m17 m23 m29 m35 m41 m47
m6 m12 m18 m24 m30 m36 m42 m48...
I tried to use Sort function but doesn't work at all.
Thanks in advances,
JW
I have the dataset like this:
the question is: how to insert m2 between m1 and m10,
insert m3 between m2 and m10
insert m4 between m3 and m10....
orinigal dataset:
m1 m15 m20 m26 m31 m37
m10 m16 m21 m27 m32 m38
m11 m17 m22 m28 m33 m39
m12 m18 m23 m29 m34 m4
m13 m19 m24 m3 m35 m40
m14 m2 m25 m30 m36 m41....
the final dataset should be like that:
m1 m7 m13 m19 m25 m31 m37 m43
m2 m8 m14 m20 m26 m32 m38 m44
m3 m9 m15 m21 m27 m33 m39 m45
m4 m10 m16 m22 m28 m34 m40 m46
m5 m11 m17 m23 m29 m35 m41 m47
m6 m12 m18 m24 m30 m36 m42 m48...
I tried to use Sort function but doesn't work at all.
Thanks in advances,
JW