I have a column with numbers some numbers are the same.
I need to total how many times a number row appears; group it; then total
another column number value and place blank rows inbetween each.
Like this...

from this:

column 1 | column2 | column 3 | column 4
-------------------------------------------
1 | 1212 | name A | 1.09
1 | 1213 | name B | 1.23
1 | 1219 | name C | 2.98
1 | 1212 | name A | 2.11
1 | 1213 | name B | 3.22
1 | 1219 | name C | 3.24
1 | 1219 | name C | 5.01
1 | 1212 | name A | 2.03

To this:

column 1 | column2 | column 3 | column 4
-------------------------------------------
| | |
3 | 1212 | name A | 5.23
| | |
2 | 1213 | name B | 4.45
| | |
3 | 1219 | name C |11.23


I think I can use the =sum() for columns 1 and 4 and record a macro to import
and sort acending.
I don't know how I can do this grouping referencing column 2 and then space
it with blank rows.