How to combine data measured in different units
I have a JMP Table that contains data measured hourly at about 50 different stations. At each station the data is sometimes reported in ppm, other times in ppb, occasionally in both units and occasionally, there are no measurements at all. It's a pretty large dataset and I'm wondering - how do I automate combining the columns that pertain to each station into a single column in one system of uni...