Spreadsheet: 269817d1381296100-how-to-combine-three-table-in-another-spreadsheet-problem-telephone-first-last
Sheet: Roaming & IDD & SMS

If there are no record, please input "No record" in A2, otherwise, please paste the record in this page
 |  | Roaming |  |  | IDD | SMS |  |  |  | Roaming & IDD
Date (dd-mm-yyyy) | Time | Fet | Origination | Destination | City | Called Number | Service / Content Description | Charging Type | Inter-Operator SMS | Number | Min | Amount (HK$) | Narratives | Category | Matter Number | Call Type
19-07-2013 | 12:58 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 0.4 | 26.91
19-07-2013 | 19:00 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 0.1 | 9.97
19-07-2013 | 19:01 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 3.1 | 39.88
20-07-2013 | 14:32 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 0.1 | 3.33
20-07-2013 | 14:38 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 1 | 16.66
21-07-2013 | 09:04 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 2.5 | 29.91
21-07-2013 | 09:11 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 0.3 | 9.97
21-07-2013 | 10:16 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 5.2 | 56.55
21-07-2013 | 10:24 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 5.2 | 56.55
21-07-2013 | 10:39 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 0.7 | 26.39
21-07-2013 | 10:40 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 1 | 9.42
21-07-2013 | 10:44 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 2.8 | 79.19
21-07-2013 | 11:06 | -- | Hong Kong | UK |  |  |  |  |  | 123456789 | 0.3 | 29.06
21-07-2013 | 11:07 | -- | Hong Kong | UK |  |  |  |  |  | 123456789 | 6.3 | 203.4
21-07-2013 | 14:59 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 1.5 | 19.94
21-07-2013 | 16:34 | -- | Hong Kong | UK |  |  |  |  |  | 123456789 | 0.4 | 23.15
22-07-2013 | 06:20 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 0.1 | 26.91
22-07-2013 | 07:25 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 0.5 | 26.91
22-07-2013 | 07:29 | -- | Hong Kong | UK |  |  |  |  |  | 123456789 | 19.4 | 475.22
22-07-2013 | 08:40 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 0.6 | 26.91
22-07-2013 | 08:44 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 0.4 | 26.91
22-07-2013 | 08:46 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 0.7 | 26.91
22-07-2013 | 08:47 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 9.6 | 269.1
22-07-2013 | 09:22 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 0.3 | 26.39
22-07-2013 | 09:53 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 8.3 | 237.56
22-07-2013 | 10:09 | -- | Hong Kong | UK |  |  |  |  |  | 123456789 | 5.9 | 127.23
22-07-2013 | 16:15 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 0.2 | 26.91
22-07-2013 | 16:16 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 5.9 | 161.46
22-07-2013 | 16:26 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 4.3 | 199.35
22-07-2013 | 16:36 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 4.2 | 199.35
22-07-2013 | 16:40 | -- | Hong Kong | UK |  |  |  |  |  | 123456789 | 2 | 47.54
22-07-2013 | 19:51 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 0.1 | 9.42
22-07-2013 | 19:51 | -- | Hong Kong | UK |  |  |  |  |  | 123456789 | 0.2 | 21.21
22-07-2013 | 19:52 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 2.7 | 28.28
22-07-2013 | 19:55 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 0.1 | 9.42
22-07-2013 | 19:55 | -- | Hong Kong | UK |  |  |  |  |  | 123456789 | 0.3 | 21.21
22-07-2013 | 19:55 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 1.5 | 18.86
22-07-2013 | 19:57 | -- | UK | *Outgoing* |  |  |  |  |  | 123456789 | 2.2 | 28.28
31-07-2013 | 16:11 | -- | Incoming | Hong Kong |  |  |  |  |  | 123456789 | 0.1 | 1.8
23-07-2013 | 17:46 |  |  |  | 001 N.Ch |  |  |  |  | 123456789 | 1 | 6.5
26-07-2013 | 10:33 |  |  |  | 001 N.Ch |  |  |  |  | 123456789 | 9.2 | 95.4
27-07-2013 | 12:54 |  |  |  | 001 N.Ch |  |  |  |  | 123456789 | 1 | 1.75
30-07-2013 | 21:09 |  |  |  | 001 U.K. |  |  |  |  | 123456789 | 1 | 1.62
30-07-2013 | 21:10 |  |  |  | 001 U.K. |  |  |  |  | 123456789 | 2 | 18
01-08-2013 | 19:12 |  |  |  | 001 Sing |  |  |  |  | 123456789 | 13.5 | 104.35
01-08-2013 | 22:34 |  |  |  | 001 U.K. |  |  |  |  | 123456789 | 3.3 | 30.26
10-08-2013 | 19:29 |  |  |  | 001 Cana |  |  |  |  | 123456789 | 7.7 | 57.99
20-08-2013 | 08:36 |  |  |  | 001 Aust |  |  |  |  | 123456789 | 1 | 5.35
20-08-2013 | 09:27 |  |  |  | 001 Aust |  |  |  |  | 123456789 | 17.7 | 141.84
20-08-2013 | 09:46 |  |  |  | 001 Aust |  |  |  |  | 123456789 | 1 | 5.12
19-07-2013 | 08:30 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
19-07-2013 | 00:56 |  |  |  |  | 123456789 | Roam-Int'l SMS |  |  |  |  | 4
19-07-2013 | 07:46 |  |  |  |  | 123456789 | Roam-Int'l SMS |  |  |  |  | 4
20-07-2013 | 07:46 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
20-07-2013 | 15:01 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
21-07-2013 | 15:03 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
21-07-2013 | 15:05 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
21-07-2013 | 15:21 |  |  |  |  | 123456789 | Roam-Int'l SMS |  |  |  |  | 4
21-07-2013 | 15:24 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
21-07-2013 | 16:14 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
21-07-2013 | 16:15 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
21-07-2013 | 16:20 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
21-07-2013 | 16:21 |  |  |  |  | 123456789 | Roam-SMS |  |  |  |  | 3
21-07-2013 | 16:22 |  |  |  |  | 123456789 | Roam-SMS |  |  |  |  | 3
21-07-2013 | 16:25 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
21-07-2013 | 16:58 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
22-07-2013 | 16:58 |  |  |  |  | 123456789 | Roam-SMS |  |  |  |  | 3
22-07-2013 | 17:00 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
22-07-2013 | 17:02 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
22-07-2013 | 17:05 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
22-07-2013 | 17:06 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
22-07-2013 | 17:07 |  |  |  |  | 123456789 | Roam-SMS |  |  |  |  | 3
22-07-2013 | 17:08 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
22-07-2013 | 21:45 |  |  |  |  | 123456789 | SMS Thereafter |  |  |  |  | 2
22-07-2013 | 21:54 |  |  |  |  | 123456789 | SMS Thereafter |  | Y |  |  | 0.6
22-07-2013 | 22:03 |  |  |  |  | 123456789 | SMS Thereafter |  | Y |  |  | 0.6
22-07-2013 | 23:14 |  |  |  |  | 123456789 | SMS Thereafter |  |  |  |  | 0
22-07-2013 | 13:29 |  |  |  |  | 123456789 | SMS Thereafter |  |  |  |  | 0
22-07-2013 | 12:13 |  |  |  |  | 123456789 | SMS Thereafter |  |  |  |  | 0
22-07-2013 | 08:43 |  |  |  |  | 123456789 | SMS Thereafter |  |  |  |  | 0
22-07-2013 | 18:58 |  |  |  |  | 123456789 | SMS Thereafter |  |  |  |  | 0
22-07-2013 | 20:12 |  |  |  |  | 123456789 | SMS Thereafter |  |  |  |  | 0
22-07-2013 | 19:51 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
22-07-2013 | 19:55 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
22-07-2013 | 19:56 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
22-07-2013 | 19:57 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
22-07-2013 | 22:15 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
22-07-2013 | 22:18 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
31-07-2013 | 22:21 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
19-07-2013 | 22:27 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
19-07-2013 | 22:27 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
19-07-2013 | 22:29 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
20-07-2013 | 16:25 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
20-07-2013 | 16:29 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
21-07-2013 | 16:30 |  |  |  |  | 123456789 | Roam-SMS |  | Y |  |  | 3.6
21-07-2013 | 21:29 |  |  |  |  | 123456789 | SMS Thereafter |  | Y |  |  | 0.6
21-07-2013 | 08:27 |  |  |  |  | 123456789 | SMS Thereafter |  |  |  |  | 0
21-07-2013 | 12:57 |  |  |  |  | 123456789 | SMS Thereafter |  |  |  |  | 2
21-07-2013 | 13:03 |  |  |  |  | 123456789 | SMS Thereafter |  |  |  |  | 2
21-07-2013 | 21:54 |  |  |  |  | 123456789 | SMS Thereafter |  | Y |  |  | 0.6
21-07-2013 | 22:12 |  |  |  |  | 123456789 | SMS Thereafter |  | Y |  |  | 0.6
21-07-2013 | 22:14 |  |  |  |  | 123456789 | SMS Thereafter |  | Y |  |  | 0.6
21-07-2013 | 22:27 |  |  |  |  | 123456789 | SMS Thereafter |  | Y |  |  | 0.6
21-07-2013 | 22:45 |  |  |  |  | 123456789 | SMS Thereafter |  | Y |  |  | 0.6
21-07-2013 | 08:38 |  |  |  |  | 123456789 | SMS Thereafter |  |  |  |  | 0
22-07-2013 | 19:36 |  |  |  |  | 123456789 | SMS Thereafter |  | Y |  |  | 0.6
22-07-2013 | 22:11 |  |  |  |  | 123456789 | SMS Thereafter |  |  |  |  | 0
22-07-2013 | 22:11 |  |  |  |  | 123456789 | SMS Thereafter |  | Y |  |  | 0.6
22-07-2013 | 23:32 |  |  |  |  | 123456789 | SMS Thereafter |  | Y |  |  | 0.6