Concatenate Columns

[sanjit11]

Is there a way to concatenate 2 columns without using the formula tool. If yes, could someone provide a solution.

Thanks .

[apathetichell]

what's your issue with formula tool?

[Qiu · Accepted solution]

@sanjit11 

I think we can  use a transpose and Summarize tool.

[atcodedog05]

@sanjit11 

As @Qiu mentioned transpose tool and summarize tool combo work great if you high n numbers of columns. You don't need to add them all in formula. You can just transpose them and contact them / do calculations on them 🙂.

[sanjit11]

apathetichell , formula tool is working fine , was just curious to know if there is any other way to do it

[sanjit11]

Thanks @Qui

[sanjit11]

Thanks @atcodedog05, got it!