that sounds hard to maintain if a new reading type comes in. this should be done dynamically
using Merge I get the following
without merge (double vision)
and it makes sense cause without merge you have 2 frames of data. So it is being helpful to differentiate one from the other.
Also I would go for 1 query approach with maybe a pivot.