This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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.