Inserting a blank line
I have a column sorted by cities and a column next to that with the numbers
that can be 5, 10, 15, 25 or 30. I need to insert a space between cities and
have a count how many 5s, 10s, 15s etc there are.
column A: column D:
Boston 30
Boston 15
Boston 5
Boston 15
(in column D) 5 1(in column E)
15 2
30 1
Detroit 10
10 1
Orlando 10
Orlando 10
Orlando 10
10 3
|