I use some scientific instruments to collect data on a computer (man
different ones).

They all give data in a long TAB of CSV stream that looks like this i
Excel:
-
random info about the machine
may be several rows
or column in different cells*

X Y1
x y1
x y1
x y1
...*

more random info cells
gap (# of rows) between data sets is
usually constant/fixed.

X Y2
X Y2
X Y2
X Y2
...[/b]-


ALL THE X COLUMNS ARE THE SAME DATA. I REALLY NEED A WAY TO COPY EAC
SERIES OF Y DATA TO ADJACENT COLUMN SO IT WILL LOOK LIKE THIS
[b]
X Y1 Y2 Y3 ...
X Y1 Y2 Y3...
X Y1 Y2 Y3...
X Y1 Y2 Y3...
..

So that I can graph the data. There may be 50-100 series i
one file.

I've attached a very small example data file for furthe
clarification/convience.

This is a very common problem but I can't find any pointers eve
searching here. I tried it with macros, but I don't think I can do i
that way. Don't have a clue where to start, but I'll try anything.

Please give me some help if you can.

Thanks.

~K

Attachment filename: ps-ppv-2.txt
Download attachment: http://www.excelforum.com/attachment.php?postid=62710
--
Message posted from http://www.ExcelForum.com