Row wise summation of dynamic columns

Question

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 Answer

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 Answer

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.