Multiple data query using time reference

[bigschlong]

Hello everyone,

I am wondering how to accomplish this task. I have multiple data from
various sources. These data have different fields, but the only thing
they have in common is the time. Is there a way for me to somehow add a
data query into a blank worksheet and use the timestamp on each of
these data to populate the blank worksheet?

I wanted to compare the timestamp on each of these data and put all of
the various field with a similar timestamp into one row on the blank
worksheet. I've been messing around with VLOOKUP, but it seems like the
only solution I can think of is programming a macro.

Any tips for a newbie?

My data files have this format:

time | data1 | data2 | data3|
time | grad1 | grad 2| grad3|

I want my blank worksheet to look like:

time | data1 | grad2 | data2| grad2 | data3 | grad3|

Thanks!

 

[Tom Ogilvy]

Seems to be a macro would be appropriate here although you might be able to
do something with a pivot table.