how arrage Z data format in to column

[Julian_prince]

 I have data format given belowe. where R1,2,3.. represent the row no.

I want the RED value as column 1 and pink value as column 2 and i don't need other values.

this the one set of data of large file.

R1-  25188992.100   132369037.23107      -636.478    25188988.340   103144687.36944
R-2      -636.478
R3-  22177365.140   116542850.29009      -610.452    22177364.080    90812597.69247
R4      -610.452
R5-  22767550.580   119644321.94308       589.867                    93229351.66707
R6-       589.868    22767547.460
R7-  20274811.160   106544869.40609       229.313    20274809.560    83021968.23749
R8-       229.313

full data file is attached here.
please sugges me .. corresponding programme..

Thanks and regards

Prince 

[RoopeshV]

Hi,

Find the attached file. Hope this is what you requried.

Regards,

Roopesh

[.aCe.]

You could try something like this:

Hope that helps.

regards,

aCe

[EvenDeejay]

Or like this: