How do I sort and put a space between each sorted choice
 

I have a spreadsheet that list the same ssn several times but with different
numbers in another column. I need to sort by A and B and input a space after
both a and b match but the whole set not each match. Then those need to sum

How do I sort and put a space between each sorted choice
 

"Stewart" wrote
I have a spreadsheet that list the same ssn several times
but with different numbers in another column.
I need to sort by A and B and input a space after
both a and b match but the whole set not each match.
Then those need to sum

Sort the table by the ssn col first,
then apply Data SubTotals
using "Sum" for the col with the numbers
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--