Collating two time series

[holp]

Hi all,

I have the following question, you may have an advice:

There are two time series as shown below. In column A the time data is given only for specific time point. In column B there are marker data (which start at the given time point and last until the next). In column C a continuous time scale is given (I just show the beginning of this column, but is goes until 114,1 sec).
My question is how I can collate these two time series, such as the time points from column A are automatically put at the correct row according to column C?

I also attach the example in a file to easier reading!
Example_I.xlsx
many thanks for your suggestions
Lisa

----------------------------------------
Time points Marker Time scale
0,0 1 0
5,6 2 0,1
11,1 3 0,2
17,3 4 0,3
22,7 1 0,4
28,9 2 0,5
35,7 3 0,6
42,2 4 0,7
48,8 1 0,8
54,2 2 0,9
60,2 3 1
65,6 4 1,1
71,7 1 1,2
76,9 2 1,3
84,6 3 1,4
90,3 4 1,5
96,9 1 1,6
102,4 2 1,7
108,5 3 1,8
114,1 4 1,9
2
2,1
2,2
2,3
2,4
etc....

[zbor]

Can you upload example workbook with your input and desired output?

[holp]

Hi

thanks for the fast answer.
Attached is now a file with the input the desired output.

Many thanks for your support,
lisa

[Ace_XL]

In Column B of outout sheet use

=LOOKUP(A2,Example_Input!$A$2:$A$6,Example_Input!$B$2:$B$6)

[holp]

Many thanks, it works fine!