For instance:

Company XX 10% A owes 5.1 Loan A
20% B owes Loan B
30% C owes

Company YY 60% A owes 4.1 Loan A
10% B owes Loan B
20% C owes

when i sort the data, say like Column A (by company), when I choose "Company
XX", only the first row appears of Company XX appears, as follows

" Company XX 10% A owes 5.1 Loan A "


Can i set anything so that, when i sort the data, all information about
company XX will appear?

My desired result is

"Company XX 10% A owes 5.1 Loan A
20% B owes Loan B
30% C owes "

Thanks