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:
