I have a question regarding the storing of two values and their corresponding units in one measurement. Let’s say we extract data from different sources where several sources have their body height stored in inches and others in centimeters. Is there a way to store all the original values in measurements with their original units AND a transformed value. So if we would take centimeters as our ultimate standard; could we store in one measurement that the value is 62 with unit “inch” and transformed value is 157.48 with unit “cm”?
If not, how to store this in a neat way if we really want to store an original and a transformed value? By making 2 measurements and relate them?
Thank you in advance!