So ive got:

Company | Street | City | State | Amount
John, Inc. | 125 Marshall Street | Philadelphia | PA | 125.00
John, Inc. | 125 Marshall Street | Philadelphia | PA | 65.00
John, Inc. | 125 Marshall Street | Philadelphia | PA | 130.00
Mike's Co. | 5349 9th Street | Exton | PA | 45.00
Mike's Co. | 5349 9th Street | Exton | PA | 66.00

and I want it to look like this:

Company | Street | City | State | Amount
John, Inc. | 125 Marshall Street | Philadelphia | PA | 320.00
Mike's Co. | 5349 9th Street | Exton | PA | 111.00

How is it done? It will be on the tail end of a macros that does a bunch of other stuff.

Thanks!!!