Attempting to flatten multiple temporal data points for single identifier

Hello, and thanks for anyone taking a look at this. I'm not particularly good with excel, but have some limited knowledge. I am working on a medical research project involving taking information from patients for multiple days. On the first day they come in, the software that I use for data collection will attach all non-temporal characteristics of the patient in numerical form on that same row. Then each additional day the patient is recorded, it only records one number to indicate a single variable (marked level) on the sample attached. What I need to accomplish is to make it so that I can somehow flatten the entry to show only the maximum value for all recorded days in one line so that each patient has only one row. I have attached an excel with what it would look like before and after ideally. Really appreciate if anyone can help me with this!

thanks for your help! I am wondering, however, will this equation work for a data set involving 500+ patients? Like an apply automatically to entire sheet method?

Originally Posted by cranialnerve

thanks for your help! I am wondering, however, will this equation work for a data set involving 500+ patients? Like an apply automatically to entire sheet method?

Nevermind, I gave this a try and it works great. Thanks!

I'm actually having a bit of trouble now. I am getting an incorrect return for my column C level. For example, see below for before/af:

3 admit_arm_1 5
3 day_1_arm_1 5
7 admit_arm_1 5
7 day_1_arm_1 6
7 day_2_arm_1 5
7 day_3_arm_1 5
7 day_4_arm_1 5
7 day_5_arm_1 6
7 day_6_arm_1 5
7 day_7_arm_1 5
7 day_8_arm_1 5
7 day_9_arm_1 5
8 admit_arm_1 5
8 day_1_arm_1 5
8 day_2_arm_1 5
8 day_3_arm_1 5


Summarized as:
3 5
7 5
8 5



As you can see, it is showing 5 for all of them when it really is: 5, 6, 5

ID numbers are fabricated for confidentiality. I included a sample of 5 patients data from rows 1-27. A patient can be enrolled for variable amount of days, but for everyday the patient is enrolled, a new column is created with the same patient identifier but different variable in the C column. What I need to do is flatten it so that I have only 1 row per patient, and that the C column will show only the maximum value attained for that specific patient (regardless of what day it occurred) on that same column. I included a sample starting at row 35. Thanks again!

That did the trick! Very grateful for your help, thanks again!