Merging columns in data table

[Pablo Carpane]

I have a data table in which the same observation is under two different names (in some cases as GSPP and TGSPP). Some rows in the data table have a value for GSPP and other rows as TGSPP, and the datatype is "Real". The rest of the cells are empty and some rows have empty values in both columns (meaning that the observation did not take place in that row, which is correct).

I need to merge or combine both in the same column but I couldn't find a way. I've tried inserting a calculated column GSPP + TGSPP and nothing happened. Replacing empty values with "0" would not work because the "0" would imply that the observation took place and its value was zero, which is not the case.

Any help is welcomed.

Thank you very much

[Fabian Duerr]

Is it either GSPP or TGSPP better never both

Then just use any aggregation function like Min, Max, Median, Avg... Since it is a single value they will return the same result.

Max([GSPP],[TGSPP])