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

S

Stewart

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
 
M

Max

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
Click to expand...

Sort the table by the ssn col first,
then apply Data > SubTotals
using "Sum" for the col with the numbers
 
Top