Add Multiple Columns into single column

[sshind58]

Hello Dears,

I have columns with c1,c2,c3,c4,c5 headers and I want to add values from them in single column "Sum C". Currently I am using formula tool, but for that I am entering all formula manually like c1+c2+c3+c4.. I have 30-40 columns and also need to add many such Sum columns. Can anyone please suggest shortcut for this?

[alexnajm]

Transpose those columns and CrossTab them back (with Sum and Total selected) should do the trick!

[alexnajm · Accepted solution]

Roland's solution here should work decently well: Solved: Adding totals to dynamic table - Alteryx Community

[sshind58]

Thank you...!!