It seems to me that the simplest way would be to add 2 more columns for the text representation that you desire, then going forward fill the text columns, leaving the numerical columns empty. When you need a value, check the text column for with/without value. If it has a value, use it, but if...