You can create a sheet with a table listing your words like tesco and then what catergory this would be like grocery.

Then on the sheet which you imported your statement include a column at the end which looks up the transaction name from the table on the other sheet and returns the appropriate category name.

Finally you can have a 3rd sheet which has a table listing each catergory and shows the totals for each category.


If you can upload a sample worksheet with an imported statement (change any details to false data of course - make sure the fake data is in the same format though) and I can show you better how this would work.