Hello,

This problem is hard to explain without an example. I am using Excel 2003.
I have two sets of data:

Set 1:

Time Value
10:18:06 1
10:18:10 3
10:18:14 5

Set 2:

Time Value
10:18:04 1
10:18:05 2
10:18:06 3
10:18:07 2
10:18:08 3
10:18:09 4
10:18:10 5
10:18:11 1
10:18:12 3
10:18:13 6
10:18:14 3

As you can see, set 1 and 2 share only some "time" values. What I would
like to do is align the "values" at shared "time" from set 1 next to set 2 so
I can create a formula to work with those two shared values. Any ideas how
to automate a task to take the two sets of data above and create the
following result:

Time Set 2 Value Set 1 Value
10:18:04 1
10:18:05 2
10:18:06 3 1
10:18:07 2
10:18:08 3
10:18:09 4
10:18:10 5 3
10:18:11 1
10:18:12 3
10:18:13 6
10:18:14 3 5

Thanks for the help!