I'm using a dataset which is very long for my research project.
This is an example how it looks at this moment (the second column is translated to: hours after trauma):
As you can see, there are several moments of measurement within one timecategory. I would like to combine measurments within one timecategory, but only the first value of any variable withing one timecategory should stay in the dataset. This is an example how it would look like:
As you can see on the first screenshot, patient 1 misses APTT after 2 hours after trauma. In the second screenshot, you can see that this missing value is replaced by the value of APTT of 3 hours after trauma (still timecategory 1). Hb en Trombo's are not adjusted as the first values within one timecategory is most important.
Do you know where I can find this option to apply these changes in a fast way to my complete database? I couldn't find anything on Google, but I don't know how this function is called. I only found tutorials about merging two datasets (= files), which is not the case in my situation.
Hope you can help me!