On Jan 31, 1:20*pm, Paul Robinson
wrote:
Hi
This looks perfect for a pivot table.
1. Select your data
2. go to Data, pivot table
3. in Excel 2000 fill in the data range & after clicking Next you will
see a button for Layout. Click this and drag Time String heading to
the Row area, Var Name to the column area and Value to the data area.
This will give you a count of each TimeString/Var Name pair. Double
click each count and you will get a separate table for it.
Not quite what you asked for but may be useful.
regards
Paul

On Jan 31, 6:48*pm, jmccaski wrote:

I have an array with over 21,000 rows. I need to analyze this but have
not been able to get it out in a useful format yet. The data looks
like this:

VarName TimeString * * *VarValue
Pos * * 27.01.2011 12:49:35 * * 32
Pres * *27.01.2011 12:49:35 * * -2
Setpt * 27.01.2011 12:49:35 * * 100
Gain * *27.01.2011 12:49:35 * * 1
Int * * 27.01.2011 12:49:35 * * 10
Pos * * 27.01.2011 12:49:36 * * 32
Pres * *27.01.2011 12:49:36 * * -2
Setpt * 27.01.2011 12:49:36 * * 100
Pos * * 27.01.2011 12:49:37 * * 32
Pres * *27.01.2011 12:49:37 * * 9
Setpt * 27.01.2011 12:49:37 * * 100
Pos * * 27.01.2011 12:49:38 * * 32
Pres * *27.01.2011 12:49:38 * * 9
Setpt * 27.01.2011 12:49:38 * * 100
Pos * * 27.01.2011 12:49:39 * * 32
Pres * *27.01.2011 12:49:39 * * 24
Setpt * 27.01.2011 12:49:39 * * 100
Pos * * 27.01.2011 12:49:40 * * 32
Pres * *27.01.2011 12:49:40 * * 24
Setpt * 27.01.2011 12:49:40 * * 100
Gain * *27.01.2011 12:49:40 * * 1
Int * * 27.01.2011 12:49:40 * * 10

I need to extract it into a format something like this in order to
chart it:

TimeString * * * * * * * * * * Pos *Press Setpt Gain Int
27.01.2011 12:49:35 * * 32 * * *-2 * * *100 * * * * *1 * *10
27.01.2011 12:49:36 * * 32 * * *-2 * * *100
27.01.2011 12:49:37 * * 32 * * *9 * * * 100
27.01.2011 12:49:38 * * 32 * * *9 * * * 100
27.01.2011 12:49:39 * * 32 * * *24 * * *100
27.01.2011 12:49:40 * * 32 * * *24 * * *100 * * * * *1 * *10

Any help would be appreciated. I've burned up a couple of days so far
with little luck.

The pivot table worked perfectly. I had never used one before. I did
need to "copy" the table into another sheet as data in order to
manipulate it, but having done that I was able to chart everything.

Thanks!!!