Consolidate Repeated Values into 1 Row
My formulation was tested in 3 ways. My data set includes the testing dates alongside the results. Test Result 3 is date agnostic so it appears in my data set in both rows. I want to consolidate my data so that it is not separated in rows by date of testing. I would like to go from something like this: to something like this: