How can add all the numbers for a total, and only Keep in all in one line.
Example below, nubers totals 9, but i only need that with one name, one
address, one city, one state, and one phone #...I have a spreadsheet that
have been working on for two days.

1 Mark Roy 5642 N. Heatherstone Drive Shreveport LA 71129-4814 (864) 844-2812
2 Mark Roy 5642 N. Heatherstone Drive Shreveport LA 71129-4814 (864) 844-2812
1 Mark Roy 5642 N. Heatherstone Drive Shreveport LA 71129-4814 (864) 844-2812
1 Mark Roy 5642 N. Heatherstone Drive Shreveport LA 71129-4814 (864) 844-2812
1 Mark Roy 5642 N. Heatherstone Drive Shreveport LA 71129-4814 (864) 844-2812
2 Mark Roy 5642 N. Heatherstone Drive Shreveport LA 71129-4814 (864) 844-2812
1 Mark Roy 5642 N. Heatherstone Drive Shreveport LA 71129-4814 (864) 844-2812