On the second set of data, im trying to use a Pi Datalink function to get some data. This data is dependent on the data from the 1st column. Instead of manually keying everything, is there a way for me to get excel to automatically do this.

For example i'm using the compressed data function and the starting times for the second set of data is suppose to be the time on each row of the first set of data. I've tried drag it, but excel doesn't want to increment the column number. I hope that make sense.

Hi Felix,

From what I'm understanding, you'd like to have the values for the 1st column data and the 2nd column data at the time stamps for the 1st column data, right?

If so, here's one way to do this:

As an example, I'm pulling Compressed Data from the tag "SINUSOID" into column C (with the time stamps in column B). I then retrieve Archive Values for the tag "SINUSOIDU" into column E, specifying the time stamp to be column B:

Regards,

Georg