Output two different sets of data in consecutive order based on timesteps

Hi,

I'm trying to output two different data sets in consecutive order based on two different durations.

Lets say I will populate the data in Column A and Column B. The duration of the first data set is 10 seconds, which gives me 11 time steps. They will hence be plotted in rows 1-11. The next data set has a duration of 20 seconds (21 time steps), and will be plotted in rows 12-32.

Now comes the tricky part! The next 11 time steps shall be the first data set, and after that comes the second data set (and so on, and so on).

I want a code that does this automatically. And note that the duration of the data sets will vary, so I need a code that will work with duration as a variable. How can I make this work?

I tried to write a code that changed from one data set to the other based on summing up the the previous steps (duration steps data set 1/2) and seeing if the sum = sum(data set 1/2). I think this should work, but I didn't have the skills to write the code.

Any help would be much appreciated!

\Carl

Hi Carl,

I think you need to post a workbook showing what you need. I can't visualize it!

Regards,

David

Please remember, your request is clearer if you attach a sample workbook.
- Reply, then Click on Go Advanced and click on the Paper Clip.

Thanks for the reply. I tried to visualize it in the attachment.

\Carl

I solved it myself using 2 FOR loops within 1 FOR loop.

\Carl