One way ..
Assuming your source data is running in A1 down
Put in B1:
=INDEX($A:$A,ROWS($1:1)*2-2+COLUMNS($A:A))
Copy B1 to C1, fill down as far as required to exhaust the data in col A
(until zeros appear)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
...
Does anyone know how to select every other line in excel? I am not
talking about highlighting it but actually selecting it so I can copy
it over to another column. What is happening is that I use some
specialized scientific equipment and it spits out lots of numbers on
top of one another the top is the x-axis and the bottom is the y-axis
and they are just alternating back and forth until it is done. I
usually get over 2000 data points and I would like to graph this
without pressing control to select over a 1000 points.
Thank you for your support and help.