I have a dataset with counts of a number of different places e.g. newcastle  24 sunderland 46 south shields 3 seaburn 67 durham 119 chester-le-street 43 wallsend 85 heaton 12 north shields 14 I'm wanting to combine a number of the rows together as they're in the same area, and also want the new single row to display the sum of all of the counts put together. For example: wallsend, heaton, north shields and newcastle could all be classed simply as newcastle with a count of (24+85+12+14) Is there a way to do this? Also if the data was all a similar name such as: 1 newcastle                                                                       2 newc                                                                       3 newcastle united                                                                       4 newcastle council as an example is there also a way to combine all these entries and the sum of there counts into one row named newcastle???? Hope you can help Thanks ... View more