cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
Fruit325
Level III

How to combine two columns info and remove redundant info?

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! 

 

 

1 REPLY 1
jthi
Super User

Re: How to combine two columns info and remove redundant info?

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

jthi_0-1727269985178.png

jthi_1-1727269992892.png

Then delete the formula from new column and rename it

jthi_3-1727270017142.png

And then remove old columns if you want to

jthi_4-1727270047527.png

 

-Jarmo