Hi,
I have below list (qty >20000 lines) in .txt format:
Task list ABCDEF1
Operation 0010 ABCDEF1
Work center PP
Control key ZM01
Number of persons 1
Work 1.0 HR
Duration 1.0 HR
Task list ABCDEF2
Operation 0010 ABCDEF2
Work center QQ
Control key ZM01
Number of persons 1
Work 2.0 HR
Duration 2.0 HR
Task list ABCDEF3
Operation 0010 ABCDEF3
Work center RR
Control key ZM01
Number of persons 1
Work 35.0 HR
Duration 35.0 HR
Task list ABCDEF4
Operation 0010 ABCDEF4A
Work center SS
Control key ZM01
Number of persons 1
Work 1.0 HR
Duration 1.0 HR
PRT ABCDEFGH
PRT cat. O
Item 0010
Quantity 1.000 EA
Operation 0020 ABCDEF4B
Work center SS
Control key ZM01
Number of persons 1
Work 0.5 HR
Duration 0.5 HR
I need to have the list in table format in Excel with below Headings:
[Task List][Operation][Work center][Control Key][Number ofpersons][Work][Duration][PRT][PRT CAT]
Kindly advice most efficient method to convert above list to table.
Thanks in advance
I have below list (qty >20000 lines) in .txt format:
Task list ABCDEF1
Operation 0010 ABCDEF1
Work center PP
Control key ZM01
Number of persons 1
Work 1.0 HR
Duration 1.0 HR
Task list ABCDEF2
Operation 0010 ABCDEF2
Work center QQ
Control key ZM01
Number of persons 1
Work 2.0 HR
Duration 2.0 HR
Task list ABCDEF3
Operation 0010 ABCDEF3
Work center RR
Control key ZM01
Number of persons 1
Work 35.0 HR
Duration 35.0 HR
Task list ABCDEF4
Operation 0010 ABCDEF4A
Work center SS
Control key ZM01
Number of persons 1
Work 1.0 HR
Duration 1.0 HR
PRT ABCDEFGH
PRT cat. O
Item 0010
Quantity 1.000 EA
Operation 0020 ABCDEF4B
Work center SS
Control key ZM01
Number of persons 1
Work 0.5 HR
Duration 0.5 HR
I need to have the list in table format in Excel with below Headings:
[Task List][Operation][Work center][Control Key][Number ofpersons][Work][Duration][PRT][PRT CAT]
Kindly advice most efficient method to convert above list to table.
Thanks in advance