I have two sets of columns. Each set has two columns.

For the 1st set, the left column is a date/time stamp, and the right column is an input value. These values have generally been taken every other hour, with a few consecutive hours mixed in.

For the 2nd set, the left column is a date/time stamp, and the right column is an output value. These values have generally been taken every hour, with a few skipped hours of no values.

I would like to create a 3rd set with three columns: #1 = date/time stamp (every consecutive hour - no problem I can do that); #2 input values; #3 output values. Here are is my issues - how would I copy from the 1st set and then paste to the 3rd set #2 column according to is associated date/time stamp? And then how would I copy from the 2nd set and then paste to the 3rd set #3 column according to its associated date/time stamp? I have over 10,000 data points so I was hoping there is a repetitive process.

Thanks for any help you can provide.