Assigning time scales to trials

[holp]

Hi all,

I have the following question, you may have an advice:
There are two time series as shown in the example file (sheet: Example_Input): column A is the data, column B is a time scale and in column C are the trials (each trial represents a separate part of an experiment). I now would like to assign a second time scale that however represents the time for each trial separately (as shown in sheet: Example_Output). The time series in realty is way larger. My question, how can I automatically assign this second time scale?

I would be grateful for your advice.

thanks, Lisa

[holp]

Solved it myself using an IF function; please see the attached file for details.
cheers