Hey guys, maybe someone can figure this out. I’ve got a datatable with a department names followed by 4 numbers( 5 columns total).
There are several of the same department name but with different numbers.
Now i want to take the department names(col1) that are the same and summarize the values from the four columns into one row.
So i end up with just one row per department with the sum of all four number columns.
Im doing this with a for each loop inside a for each now, but something tells me it can be done in a simpler way?test - Copy.xlsx (9.2 KB)