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.

so you want to sort, not group?

1 Like

Yes sorry I mean sort by a name field and still retain all other aspects of the table.

Hi @Peter_Dunn , from your description, the Sorter node should allow you to do as you require, but if not please expand further on where it is deficient.

2 Likes