How to add 2 rows in Alteryx for all the numeric columns?

Question

I have a data problem wherein I need to sum two rows and paste the values in a third new row. Here is my sample dataset:

And this is the Output that I need:

That is if the value of A is "y" or "Z", I want to add them and store the values in the row where A is "T"

I tried using multirow formula but I was only able to do this for one column at a time. This is difficult as in the original dataset there are over 40 columns and this kind of summing is required multiple times.

Any help will be appreciated!

LordNeilLord · Accepted Answer

Hi @Prachi_Jhunjhunwala

You would be better to transpose the data first and then crosstab it back (summing the values) like so:

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome