Teman dan  suhu BeExcel,

Gimana cara mengubah data mentah, menjadi table dengan data yang bisa 
dimanfaatkan. 

Terima kasih.
Emi Lestari


DATA MENTAH
To:
552225
Sent:
Tuesday, 26 June 2012 10:34 PM
200000070
wiiieieimmakkkd
--
To:
200000070
Sent:
Thursday, 28 June 2012 5:22 PM
552225
hhddk
To:
552225
Sent:
Thursday, 28 June 2012 5:25 PM
200000070
hfgfdfddn  jjj
***
To:
200000070
Sent:
Thursday, 28 June 2012 5:27 PM
552225
hjj klllldddd
To:
552225
Sent:
Thursday, 28 June 2012 5:30 PM
200000070
sdffg jjjk nnbb
***

Hasil yang diharapkan
NoTanggal       WaktuPengirim        Penerima        Mesej
126 Juni 201210:34 PM200000070552225wiiieieimmakkkd
228 Juni 20125:22 PM552225200000070hhddk
328 Juni 2012 5:25 PM200000070552225hfgfdfddn  jjj
428 Juni 2012 5:27 PM552225200000070hjj klllldddd
528 Juni 20125:30 PM200000070552225sdffg jjjk nnbb

Attachment: Mengubah struktur data.xls
Description: MS-Excel spreadsheet

Kirim email ke