Hi,  I have the results of an append operation as follows: ID Col3 col4 col5 a     abc a abc No   a xyz Yes   b     abc b     xyz b xyz No   b fgh Yes   b abc No   f     abc f abc No   f xyz No   i     abc i     xyz i xyz Yes   i abc No   The result from the first table and the result from the second should be merged respectively. I cannot use | stats values(col1) values(col2) values(col3) by ID because I cannot lose the distinction between "No" and "Yes" for Col3. I want to create a result as follows: ID Col3 col4 col5 a abc No abc a xyz Yes   b xyz No xyz b fgh Yes   b abc No abc f abc No abc f xyz No   i xyz Yes xyz i abc No abc   I think something like SQL's full join would do the trick, but I am totally stuck. ... View more