Table calculating of one colomn based another columns value

Hi

i need some help im trying to calculate the difference in time between the following:

for an example i wish to know the difference between the date of failure on the first row of C01 until the next entry of C01, and so on. I dont know how to progress with a problem as such. If you need more information let me know and i shall provide it.

Answer 1

[Star Strider]

If the desire is to have a table with the variables being the ‘TurbineID’, see if the unstack function will work. Analysing the data for a particular turbine would likely then be easier.

.