Hello,
I can think of non-elegant ways to achieve what I'm going after; I'm here to ask if there is an elegant way to meet my goal.
In the excel screenshots below, the first table is what I'm starting with:
and the second table is what I want to achieve:
Explanation: I have some data which came in as the result of two different processes, and I need to combine the results.
In the first table, I have a sample of 3 records which are sent to me as a union of the two processes, called CONDITION 1 and CONDITION 2.
Notice that Record 1 has a value in CONDITION 1, and Record 2 has a value in CONDITION 2. They both have the same values in the first 3 fields.
Notice that Record 1/2 is different than Record 2 in that they have different values in the second field.
What I want to do is to group the two records where the first three fields are the same, then do some sort of merging so that the null values get replaced by whatever non-null value lives in the same field in a different record. The resulting record would look like the first record in the second screenshot.
I tried digging around the crosstab tool and came up with comically bad results.
Thanks,
Nick
