Jump to content

Merging columns in data table

Pablo Carpane

Recommended Posts

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...