Hi, I have a data set that i will like to reduce the number of rows by summing the values of the each column for certain values of the variable SpdCat (1,2,3,4 and 5), and put it in one row (that i will index 1) of the same dimension. So, each time i see rows that has 1,2,3,4, and 5 as index in the SpdCat column, i want to sum the value of those columns. Here is a screen shot of the data Can some one help here?
... View more