Excel 2007 Combining two tables

[Runar]

I have 2 tables which both are a function of time. The number of lines in the
tables are different and the time span is not regular . I would like to:

- merge this 2 tables
- after merging there will some timestamp which are double. Get the correct
data set and get rid of the extra timestamp and data
- fill out the missing dataset by correlation

 

[Ashish Mathur]

Hi,

Please be more specific about your question. Please post an example as
well.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Runar]

Hi,

attached is an example.

Tabel 1 Tabel 2

Time Var 1 Time Var 2
01:00:00 1 01:00:00 10
01:00:10 2 01:00:05 15
01:00:20 3 01:00:10 20
01:00:30 4 01:00:25 30
01:00:30 40
Merge them to one tabel:
Time Var 1 Var 2
01:00:00 1 10
01:00:05 ? 15
01:00:10 2 20
01:00:20 3 ?
01:00:25 ? 30
01:00:30 4 40

The '?' has to be filled inn by iteration and correlation between the
variables.


Ashish Mathur skrev:

 

[Ashish Mathur]

Hi,

I am not quite sure of the co-relation but you can use the VLOOKUP()
function to combine the Var 1 and Var 2 values,

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Herbert Seidenberg]

Using Excel 2007, Pivot Table,
Consolidate, Trend:
http://www.savefile.com/files/1797221