Creating a Variance Row

[ebledsoe22]

Hello,

I have 2 rows and 42 columns of data not including the header row, and I need to create a third row with the variance between the first two rows. I want to subtract row record number 20 from row record number 25 for each column starting with the total column. How can I do this in Alteryx? I've tried Multi-field, Multi-row, and generate row tools, but I can't seem to get it right. I feel like I am on the right path, but I need a little help building out the tools. Attached is my scrubbed data set.

Thank you in advance!

[binuacs · Accepted solution]

@ebledsoe22 One way of doing this

[Raj]

You can include transpose and cross tab to with formula tool to achieve this.

[nagakavyasri]

@ebledsoe22 

[ebledsoe22]

Thank you so much. This is perfect, and will help for other workflows.