How to combine two columns info and remove redundant info?

Question

Hi I want to get some advice of combining columns.

Here I have column 1 and 2 and these two columns are actually containing the same info of interest. I want to combine them together and remove repeat info.

Original table:

Column1 Column2

1              1

2

3              3

Final table:

Column

1

2

3

Thank you!

jthi · Answer

If they are numerical categorical you can still use that kind of approach. If they are characters, there are still many different options and which to use can depend a little bit on your data, below is one simple example

If(
	Is Missing(:Column 1), :Column 2,
	Is Missing(:Column 2), :Column 1,
	:Column 1
)

Fruit325 · Answer

Oh that's a good idea and I have not thought abou it...

So.. what if the values are categorical...?

jthi · Answer

If they are always same, you can create new column which is some summary statistic of those columns (min, max, mean, median,...)

Then delete the formula from new column and rename it

And then remove old columns if you want to