Spreadsheet: 121644d1316213907-combining-multiple-cell-information-into-one-cell-lose-blanks
Sheet: Sheet1

Date | Source Document # | [NAME] | Expenditure Details | Amount
13-Apr-10 | MECMS70181 | Provincial Airlines | Ticket Number: [PHONE]; Departure Date: 14-Apr-10; Departure Flight Time: | 248.72 |  | Ticket Number: [PHONE]; Departure Date: 14-Apr-10; Departure Flight Time:13:15; [NAME]: 14:30; Departure Location From: St Anthony;Departure Location To: [NAME]; Number of Trips: 0.5
 |  |  | 13:15; [NAME]: 14:30; Departure Location From: [NAME];
 |  |  | Departure Location To: [NAME]; Number of Trips: 0.5
14-Apr-10 | MECMS70181 |  | HNIS Dinner | 22.32 |  | HNIS Dinner
14-Apr-10 | MECMS70181 |  | HNIS Priv Vehicle Usage - Number of Trips: 0; Description: Travel from St. | 23.43 |  | HNIS Priv Vehicle Usage - Number of Trips: 0; Description: Travel from St.Anthony to St. Anthony Airport
 |  |  | Anthony to St. Anthony Airport
14-Apr-10 | MECMS70181 |  | HNIS Lunch | 13.39 |  | HNIS Lunch
15-Apr-10 | MECMS70181 | Provincial Airlines | Ticket Number: [PHONE]; Departure Date: 17-Apr-10; Departure Flight Time: | 256.29 |  | Ticket Number: [PHONE]; Departure Date: 17-Apr-10; Departure Flight Time:09:30; [NAME]: 10:45; Departure Location From: [NAME] Intl;Departure Location To: [NAME]; Number of Trips: 0.5
 |  |  | 09:30; [NAME]: 10:45; Departure Location From: [NAME];
 |  |  | Departure Location To: [NAME]; Number of Trips: 0.5
15-Apr-10 to | MECMS70181 |  | HNIS Per Diem | 89.29 |  | HNIS Per Diem
16-Apr-10
16-Apr-10 | MECMS70181 | National Car | Rental Start Date: 14-Apr-10; Rental End Date: 16-Apr-10; Other Description: | 130.34 |  | Rental Start Date: 14-Apr-10; Rental End Date: 16-Apr-10; Other Description:Rental Agreement #: 161778980; Number of Trips: 0
 |  |  | Rental Agreement #: 161778980; Number of Trips: 0
16-Apr-10 | MECMS70181 | Holiday Inn | Accommodations Start Date: 14-Apr-10; Accommodations End Date: 15-Apr-10; | 250.54 |  | Accommodations Start Date: 14-Apr-10; Accommodations End Date: 15-Apr-10;Number of Nights: 02
 |  |  | Number of Nights: 02
16-Apr-10 | MECMS72251 | Nfld. Drive Esso | Description: Gas for Rental | 18.76 |  | Description: Gas for Rental
17-Apr-10 | MECMS70181 |  | HNIS Priv Vehicle Usage - Number of Trips: 0; Description: Travel from St. | 23.43 |  | HNIS Priv Vehicle Usage - Number of Trips: 0; Description: Travel from St.Anthony Airport to St. Anthony
 |  |  | [NAME] to St. Anthony
17-Apr-10 | MECMS70181 | National Car | Rental Start Date: 16-Apr-10; Rental End Date: 17-Apr-10; Other Description: | 77.76 |  | Rental Start Date: 16-Apr-10; Rental End Date: 17-Apr-10; Other Description:Rental Agreement #161784155; Number of Trips: 0
 |  |  | Rental Agreement #161784155; Number of Trips: 0
17-Apr-10 | MECMS70181 | Holiday Inn | Accommodations Start Date: 16-Apr-10; Accommodations End Date: 16-Apr-10; | 125.27 |  | Accommodations Start Date: 16-Apr-10; Accommodations End Date: 16-Apr-10;Number of Nights: 01
 |  |  | Number of Nights: 01
17-Apr-10 | MECMS70181 |  | HNIS Breakfast | 8.93 |  | HNIS Breakfast
17-Apr-10 | MECMS72251 | Nfld. Drive Esso | Description: Gas for Rental | 16.96 |  | Description: Gas for Rental
18-Apr-10 | MECMS70181 |  | HNIS Lunch | 13.39 |  | HNIS Lunch
18-Apr-10 | MECMS70181 |  | HNIS Dinner | 22.32 |  | HNIS Dinner
22-Apr-10 | MECMS70181 | National Car | Rental Start Date: 18-Apr-10; Rental End Date: 18-Apr-10; Number of Trips: 0 | 65.17 |  | Rental Start Date: 18-Apr-10; Rental End Date: 18-Apr-10; Number of Trips: 0
22-Apr-10 | MECMS70181 | Holiday Inn | Accommodations Start Date: 18-Apr-10; Accommodations End Date: 18-Apr-10; | 125.27 |  | Accommodations Start Date: 18-Apr-10; Accommodations End Date: 18-Apr-10;Number of Nights: 01HNIS Per Diem:test
 |  |  | Number of Nights: 01
04-Jul-10 to |  |  | HNIS Per Diem: | 178.57
07-Jul-10 |  |  | test
04-Jul-10 | MECMS80247 |  | HNIS Priv Vehicle Usage - Number of Trips: 0.5; Description: Travelled from St. | 326.16 |  | HNIS Priv Vehicle Usage - Number of Trips: 0.5; Description: Travelled from St.Anthony to St. John's
 |  |  | [NAME] to St. John's
04-Jul-10 to | MECMS80247 |  | HNIS Private Accom(Island) | 212 |  | Anthony to St. John'sHNIS Private Accom(Island)
07-Jul-10