Parse file and show in a particular format in excel sheet

HI All,

I am a beginner to VBA script . I need a urgent help you from you guys.
I need to parse two text files and to show the items in excel in a particular format.

Input
--------------
Time Input file1:
===========
|TIME|THREAD_ID:3086054296|dtcp_Init|ENTRY|13:16:825897777:635006|
|TIME|THREAD_ID:3086054296|dtcp_Init|EXIT|13:16:825897777:695502|

|TIME|THREAD_ID:3086063296|ake_socketSendBuffer|ENTRY|13:16:825897777:853741|
|TIME|THREAD_ID:3086063296|ake_socketSendBuffer|EXIT|13:16:825897777:855223|
.....

Heap Input File 2:
===========
|HEAP|THREAD_ID:3101717400|dtcp_Init|Total=16384|used=9744|free=6640|
|HEAP|THREAD_ID:3101717400|dtcp_Init|Total=16384|used=9936|free=6448|
|HEAP|THREAD_ID:3101717400|dtcp_ContextCreate|Total=16384|used=13272|free=3112|
|HEAP|THREAD_ID:3101725816|dtcp_AuthenticationSessionCreate|Total=20480|used=13320|free=7160|
|HEAP|THREAD_ID:3101725816|dtcp_DeviceAuthenticate|Total=20480|used=13344|free=7136|
....

Output in Excel:
------------------
As attached

Please help.

Thank you
PD

AttachmentSize
Profile.xlsx10.51 KB
memoryprofile_log.txt982.85 KB