Row wise summation of dynamic columns

[hash_89]

I need to do a row wise summation of a few columns that are dynamic. The ones highlighted in yellow needs to be used for summing the values in these columns. These columns are dynamic and hence, i cannot write a formula using all these columns. How can i get the desired results like how i have showed in the output?

Input:

[JamesMA · Accepted solution]

Hi @hash_89 

Below I've attached the solution to this issue.

It will involve transposing the data and aggreating it before joining back together.

Let me know if it works for you.

[kelsey_kincaid · Accepted solution]

Hi @hash_89 -

You could try using a transpose tool grouping by name, class, year and then a cross tab grouping by name, class, year with your new 'names' as the columns. Then add a total column from there. Example below & attached.