View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Vince Vince is offline
external usenet poster
 
Posts: 102
Default Interleaving arrays

I have two sets of arrays.

Array one contains a column of time values with a fixed interval.

Array two contains a column of time values with random interval.

I need to correlate the data related to each time value to a common
time-base array so that, for example, it can be plotted.

The problem is that the arrays are long (10k samples), so I need an
automated way to do this. I use the term 'interleave' to mean how do I get
the two arrays of time values merged into one array that runs sequentially,
while still maintaining some relationship to the data values associated with
each initial array.

Hope this makes some sense to someone!

Thanks,
vince