How to transform the data in txt file into excel using macro

[kelvin_vyk]

Hi Guys,

I am some doubt on doing the macro to transform multi txt file into 1 excel file.

Pls help!!

Below are my data in txt file.

Machine ID : PM51-BWD06
Recipe :SESVENNA_PKG001
Operator ID :10153
Start :22/10/2017/10:34:44
End :22/10/2017 12:02:40
Process Time :01:17:35
Idling Time :00:04:24
Stop Time :00:05:54
Total ****** Tray Out :38
Tray ID
ECEBS17AL14823_SB20
ECEBS17AL14823_SB19
ECEBS17AL14823_SB36
ECEBS17AL14823_SB35
ECEBS17AL14823_SB34
ECEBS17AL14823_SB33
ECEBS17AL14823_SB38
ECEBS17AL14823_SB37
ECEBS17AL14823_SB18
ECEBS17AL14823_SB17
ECEBS17AL14823_SB16
ECEBS17AL14823_SB15
ECEBS17AL14823_SB06
ECEBS17AL14823_SB05
ECEBS17AL14823_SB04
ECEBS17AL14823_SB03
ECEBS17AL14823_SB02
ECEBS17AL14823_SB01
ECEBS17AL14823_SB12
ECEBS17AL14823_SB11
ECEBS17AL14823_SB10
ECEBS17AL14823_SB09
ECEBS17AL14823_SB08
ECEBS17AL14823_SB07
ECEBS17AL14823_SB26
ECEBS17AL14823_SB25
ECEBS17AL14823_SB24
ECEBS17AL14823_SB23
ECEBS17AL14823_SB22
ECEBS17AL14823_SB21
ECEBS17AL14823_SB32
ECEBS17AL14823_SB31
ECEBS17AL14823_SB14
ECEBS17AL14823_SB13
ECEBS17AL14823_SB30
ECEBS17AL14823_SB29
ECEBS17AL14823_SB28
ECEBS17AL14823_SB27
Total Offload Tray 1 Out :26
Tray ID
ECEBS17AL14823_1_01=126
ECEBS17AL14823_1_02=126
ECEBS17AL14823_1_03=126
ECEBS17AL14823_1_04=126
ECEBS17AL14823_1_05=126
ECEBS17AL14823_1_06=126
ECEBS17AL14823_1_07=126
ECEBS17AL14823_1_08=126
ECEBS17AL14823_1_09=126
ECEBS17AL14823_1_10=126
ECEBS17AL14823_1_11=126
ECEBS17AL14823_1_12=126
ECEBS17AL14823_1_13=126
ECEBS17AL14823_1_14=126
ECEBS17AL14823_1_15=126
ECEBS17AL14823_1_16=126
ECEBS17AL14823_1_17=126
ECEBS17AL14823_1_18=126
ECEBS17AL14823_1_19=126
ECEBS17AL14823_1_20=126
ECEBS17AL14823_1_21=126
ECEBS17AL14823_1_22=126
ECEBS17AL14823_1_23=126
ECEBS17AL14823_1_24=126
ECEBS17AL14823_1_25=126
ECEBS17AL14823_1_26=3
Total Offload Tray 2 Out :1
Tray ID
ECEBS17AL14823_2_01=17
Total Offload Tray 3 Out :8
Tray ID
ECEBS17AL14823_3_01=126
ECEBS17AL14823_3_02=126
ECEBS17AL14823_3_03=126
ECEBS17AL14823_3_04=126
ECEBS17AL14823_3_05=126
ECEBS17AL14823_3_06=126
ECEBS17AL14823_3_07=126
ECEBS17AL14823_3_08=14
Total Offload Tray 4 Out :1
Tray ID
ECEBS17AL14823_MM01=0
Total Offload Tray 5 Out :1
Tray ID
ECEBS17AL14823_VF01=0
Total Offload Tray 6 Out :1
Tray ID
ECEBS17AL14823_MM02=0
Total 2D In Lot : 4115
BIN 1 = 3202
BIN 3 = 896
BIN 2 = 17
Total 2D Out Lot : 4052
Total Unit Tray 1 Out :3153 ,77.81%
Total Unit Tray 2 Out :17 ,0.42%
Total Unit Tray 3 Out :882 ,21.77%
Total Unit Tray 4 Out :0 ,0%
Total Unit Tray 5 Out :0 ,0%
Total Unit Tray 6 Out :0 ,0%
MTBF :01:17:35
MTBA :00:07:03
No of Alarm :11

I want in excel like this

 

[kelvin_vyk]

 

[Rick Rothstein]

You cannot post a picture that is located on your home computer's hard drive. You will need to use a file sharing service like DropBox.

 

[kelvin_vyk]

https://www.dropbox.com/s/9183p8gdh66fd9e/Capture.PNG?dl=0