I have an excel 2010 document that I would like to sort in a specific way. I have been looking in excel and googleing but haven't found what I am looking for.
One of the columns have data that looks like this
and so on, the 3 digits after the first 3 is what I want to group things by, so in the above example nic is what I want to group. And there are several entries, so for example
so I want to group we1, nic, and nad together. Also there is another column that list the monitors attached to these computers, and I only want the 17 monitors. So it would look like
so after grouping the data it will look like
and what would be great would be a final total column
d01we1ds0001a 17 1
d01nicds0001a 17 2
So any ideas how to do this?