Sum columns by code

[AG21]

Hi - newbie question I couldn't find an answer for. I have a sheet structured like below. 

Both columns and rows will increase over time. I can't find an elegant way to group and sum by column heading which also allows for dynamic rows/columns. 

[PhilipMannering]

Hi @AG21 

This might work,

Alteryx won't let you have more than one field name the same. So it appends a number. So I pivot the data > chop off that digit from the field name and sum it up. (You might need to replace \d$ with \d+$ if you have more than 9 fields named the same!)

[AG21]

Hi Philip, 

Thank you for the reply.. I'm not getting the expected results with the suggested workflow. 

Any other suggestions? Thoughts on how to adjust the data structure? I could pre-aggregate columns in excel with a simple sumif formula but prefer to keep contained in the flow. 

-Anthony 

[atcodedog05]

Hi @AG21 

Can you share the sample data in excel.