Sorting a table by a name field alphabetically and retaining all other columns and rows

Hi there, I have an excel table in my workflow the row records have an account manager name field, what i would like to do is group the rows by the account manger name. When i did this i lost all other rows and columns. The result required is the same as an a-z sort in excel.