Grouping and sorting data

Dear all,

i have a query regarding the sorting of data. I have a table of data say A, B, C etc, however D has 2 sets of data (please see attached for illustration)

When I sort the data by 'total amount', I would like the two sets of numbers for D and G to be grouped together, is there anyway that this can be done?

Thanks for your help in advance!

Cheers,
JA