Is there a way to concatenate 2 columns without using the formula tool. If yes, could someone provide a solution.
Thanks .
@sanjit11
I think we can use a transpose and Summarize tool.
what's your issue with formula tool?
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 🙂.
apathetichell , formula tool is working fine , was just curious to know if there is any other way to do it
Thanks @Qui
Thanks @atcodedog05, got it!