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:
- Use the "Compressed Data" function to get your 1st column data, as you've already done.
- For the 2nd column data, use the "Archive Value" function and select the 1st column data's time stamps as the 2nd column data's time stamp. Remove the '$' (lock) before the row number so that the next row would automatically be used if you copy this down.
- Copy the "Archive Value" query you just made in Step 2 for however many time stamps you have.
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: