Spreadsheet: 136186d1326464708-merging-multiple-rows-into-a-single-row-probebun
Sheet: Sheet1

company code | company names | address | ZIP | CITY | region | tel1 | tel2 | position | ammount of installement | interest | expense | Recovery Charges Amount | total ampunt | COMPANYCODE | invoice nr. | invoice date | expiration date | balance | total balance
A | SERVICE P | V TOSCANA 2 | 20060 | VIGNATE | MI |  |  | [PHONE] | 1387.66 | 146.9589 | 0 | 0 | 1534.6189 | [PHONE] | 0155190900426228 | 2008-11-08 00:00:00 | 2008-11-28 00:00:00 | 1387.66
A | EDIL SRL | VIA CONCORDIA 19 | 20077 | ASSAGO | MI |  |  | [PHONE] | 1053.78 | 241.7087 | 0 | 0 | 1295.4887 | [PHONE] | 0157145070311214 | 2005-11-09 00:00:00 | 2005-11-29 00:00:00 | 240.28
A | EDIL SRL | VIA CONCORDIA 19 | 20077 | ASSAGO | MI |  |  | [PHONE] | 1053.78 | 241.7087 | 0 | 0 | 1295.4887 | [PHONE] | 0157145070311212 | 2005-07-10 00:00:00 | 2006-06-21 00:00:00 | 63.42
A | EDIL SRL | VIA CONCORDIA 19 | 20077 | ASSAGO | MI |  |  | [PHONE] | 1053.78 | 241.7087 | 0 | 0 | 1295.4887 | [PHONE] | 0157145070311213 | 2005-09-09 00:00:00 | 2005-09-29 00:00:00 | 69.34
A | EDIL SRL | VIA CONCORDIA 19 | 20077 | ASSAGO | MI |  |  | [PHONE] | 1053.78 | 241.7087 | 0 | 0 | 1295.4887 | [PHONE] | 0157145070311217 | 2006-05-17 00:00:00 | 2006-06-06 00:00:00 | 132.67
A | EDIL SRL | VIA CONCORDIA 19 | 20077 | ASSAGO | MI |  |  | [PHONE] | 1053.78 | 241.7087 | 0 | 0 | 1295.4887 | [PHONE] | 0157145070311216 | 2006-03-15 00:00:00 | 2006-04-04 00:00:00 | 470.27
A | EDIL SRL | VIA CONCORDIA 19 | 20077 | ASSAGO | MI |  |  | [PHONE] | 1053.78 | 241.7087 | 0 | 0 | 1295.4887 | [PHONE] | 0157145070311215 | 2006-01-19 00:00:00 | 2006-02-08 00:00:00 | 77.8
A | FLORE SRL | VIA CAV. BRUSA 36 | 21050 | MALNATE | VA |  |  | [PHONE] | 1572.17 | 305.9267 | 0 | 0 | 1878.0967 | [PHONE] | 0121832090200517 | 2006-11-17 00:00:00 | 2006-12-07 00:00:00 | 1515.48
A | FLORE SRL | VIA CAV. BRUSA 36 | 21050 | MALNATE | VA |  |  | [PHONE] | 1572.17 | 305.9267 | 0 | 0 | 1878.0967 | [PHONE] | 0121832090200516 | 2006-09-09 00:00:00 | 2007-02-19 00:00:00 | 56.69
DESIRED RESULT
company code | company names | address | ZIP | CITY | region | tel1 | tel2 | position | ammount of installement | interest | expense | Recovery Charges Amount | total ampunt | COMPANYCODE | invoice nr. | invoice date | expiration date | balance
A | SERVICE P | V TOSCANA 2 | 20060 | VIGNATE | MI |  |  | [PHONE] | 1387.66 | 146.9589 | 0 | 0 | 1534.6189 | [PHONE] | 0155190900426228 | 2008-11-08 00:00:00 | 2008-11-28 00:00:00 | 1387.66 | 1387.66
A | EDIL SRL | VIA CONCORDIA 19 | 20077 | ASSAGO | MI |  |  | [PHONE] | 1053.78 | 241.7087 | 0 | 0 | 1295.4887 | [PHONE] | 0157145070311214, 0157145070311212, 0157145070311213, 0157145070311217, 0157145070311216, 0157145070311215 | 11/9/2005, 7/10/2005, 9/9/2005, 5/17/2006, 3/15/2006, 1/19/2006 | 11/29/2005, 6/21/2006, 9/29/2005, 6/6/2006, 4/4/2006, 2/8/2006 | 240.28, 63.42, 69.34, 132.67, 470.27, 77.80 | 1053.78
A | FLORE SRL | VIA CAV. BRUSA 36 | 21050 | MALNATE | VA |  |  | [PHONE] | 1572.17 | 305.9267 | 0 | 0 | 1878.0967 | [PHONE] | 0121832090200517, 0121832090200516 | 11/17/2006, 9/9/2006 | 12/7/2006, 2/19/2007 | 1515.48, 56.69 | 1572.17