This might be a quite simple question to you, but it is quite complicated for me.
I have the attached excel with a list of patients filled with some parameters from testing equipment. To be more specific, we have a patient who comes to our office one day and we collect some data in six measurements. The patient visits our office another time and we repeat some measurements (2-6 measurements) recording the same dataset.
I want to be able to create a new table from this complicated one with the following characteristics:
- We will use only the following columns: C, D, K, L, M, N, O, AA, AB, AD, AE, AM, BV, BW, BX, BY, BZ, CO, CQ, CV, DC, DY.
- First of all we want the data to be sorted automatically by date and time on column D and then by column DY.
- Afterwards, for each appointment (certain day) we want ALL the data to be put in the SAME row. That is, we want data on column C, K, L, M, N, to be read once, and the rest of the desired columns to have the following format: D, O, DY, and then all the data collected on the specified time (column D) and position (column DY) (please see tab RESULTS on the attached excel to understand what I am saying).
If all these are understandable, please send me your comments.
It is a very crucial matter for me, because I must have this ready by Wednesday June 16, 2010.