Hi,
I'm trying to sum all the data in every existing columns. However, the summarize tool will need to predefine the field header. What if my input data will change every time (meaning instead of having 5 columns, i might have 6 columns next time). So instead of going back to add the new column in the summarize tool, is there a way to just sum all existing fields?
Please let me know if you would like an example?
Thank you for all of your help in advance.
Thanks,
Solved! Go to Solution.
Hi @calvinwong
You can use the Transpose tool to get all of the columns into one column, and then a Summarize tool that just adds up all of the values in the new column.
Cheers!
Esther
Ahhh. That works. I can just group by the Name after. Okay. Thank you so much!! I kept thinking if I need to use the Multi Field Formula. But this works. :D