Solved Sort bank transaction by payee in Excel or Word 2010

[gwatts]

I have downloaded all 2013 transactions from the bank into Excel. I want to sort the payees into itemized groups such as payments to the power company, cable television, payments for city utilities, etc.


Is there a way to accomplish this in Microsoft Word 2010, Excel , or Open Office?

Thank you.

 

[Slartybart]

Click on the uppermost left hand ColumnRow to select all cells

Find sort (data menu - sort in OpenOffice, but Excel has sort too)
When the sort dialog winodw opens, select the COLUMN that contains payees (coulmn C in my example)

Edit: the picture shows step 4 as Column B, it should be Column C

 

[gwatts]

Thank you!

 

[Slartybart]

Glad to help