Word data to excel

[chakkaravarthy.m]

Hello all,

I have below data in word (Please ref the attached sheet for clear idea. I have yellow highlighted the information in word, whcih i need in excel.)

********************************************************************************
05 JAN 2016 14:01:43 X company PAGE : 1
********************************************************************************
LEAVE AVAILED HISTORY OPTION : All leave history
===================== SEQUENCE : Dep_Name, Empno
EMP TYPE: Regular Employees
--------------------------------------------------------------------------------
SRNO ST_DATE END_DATE DAYS TYPE MTH/YR REMARKS
--------------------------------------------------------------------------------
EMPL: 201524 MR.Chaks JOINING DATE:17-SEP-2012
Unit X DEP:Accounting & Finance

10) 02-JUN-2013 05-JUN-2013 4.0 ANN LVP JUN/2013
11) 20-OCT-2013 30-OCT-2013 11.0 ANN LVP OCT/2013
12) 16-FEB-2014 20-FEB-2014 5.0 ANN LVP FEB/2014
13) 21-DEC-2014 05-FEB-2015 47.0 ANN LVP NOV/2014
14) 31-MAY-2015 04-JUN-2015 5.0 ANN LVP JUN/2015
15) 27-SEP-2015 01-OCT-2015 5.0 ANN LVP SEP/2015

-------------------------------------------------------------------------------
TOTALS :ANN LVP : 77.0 ANN LWP : 0.0 ANN ENCASH 0.0
COM LVP : 0.0 OFF.TRIP: 0.0
MED LVP : 0.0 MED LHP : 0.0 MED LWP : 0.0
SPL LVP : 0.0 SPL LHP : 0.0 SPL LWP : 0.0
MAT LVP : 0.0 MAT LHP : 0.0 HAJ LWP : 0.0 HAJ LVP : 0.0
ACC LVP : 0.0 ACC LHP : 0.0 ABSENCE: 0.0
--------------------------------------------------------------------------------

********************************************************************************
05 JAN 2016 14:01:43 X company PAGE : 2
********************************************************************************
LEAVE AVAILED HISTORY OPTION : All leave history
===================== SEQUENCE : Dep_Name, Empno
EMP TYPE: Regular Employees
--------------------------------------------------------------------------------
SRNO ST_DATE END_DATE DAYS TYPE MTH/YR REMARKS
--------------------------------------------------------------------------------
EMPL: 201854 MS.gowtham JOINING DATE:12-OCT-2014
UNIT: [DEP:Accounting & Finance

16) 06-JAN-2015 06-JAN-2015 1.0 ABSENCE FEB/2015 INIT
17) 04-FEB-2015 05-FEB-2015 2.0 MED LVP MAR/2015
18) 15-FEB-2015 15-FEB-2015 1.0 MED LVP MAR/2015
19) 09-JUN-2015 09-JUN-2015 1.0 MED LVP JUL/2015
20) 24-AUG-2015 24-AUG-2015 1.0 MED LVP SEP/2015
21) 13-DEC-2015 12-JAN-2016 31.0 ANN LVP NOV/2015

-------------------------------------------------------------------------------
TOTALS :ANN LVP : 31.0 ANN LWP : 0.0 ANN ENCASH 0.0
COM LVP : 0.0 OFF.TRIP: 0.0
MED LVP : 5.0 MED LHP : 0.0 MED LWP : 0.0
SPL LVP : 0.0 SPL LHP : 0.0 SPL LWP : 0.0
MAT LVP : 0.0 MAT LHP : 0.0 HAJ LWP : 0.0 HAJ LVP : 0.0
ACC LVP : 0.0 ACC LHP : 0.0 ABSENCE: 1.0
--------------------------------------------------------------------------------

My expectation in excel

Emp Details SRNO ST_DATE END_DATE DAYS TYPE MTH/YR REMARKS
EMPL: 201524 MR.Chaks 10) 2-Jun-13 5-Jun-13 4 ANN LVP Jun-13
EMPL: 201524 MR.Chaks 11) 20-Oct-13 30-Oct-13 11 ANN LVP Oct-13
EMPL: 201524 MR.Chaks 12) 16-Feb-14 20-Feb-14 5 ANN LVP Feb-14
EMPL: 201524 MR.Chaks 13) 21-Dec-14 5-Feb-15 47 ANN LVP Nov-14
EMPL: 201524 MR.Chaks 14) 31-May-15 4-Jun-15 5 ANN LVP Jun-15
EMPL: 201524 MR.Chaks 15) 27-Sep-15 1-Oct-15 5 ANN LVP Sep-15

EMPL: 201854 MS.gowtham 16) 6-Jan-15 6-Jan-15 1 ABSENCE Feb-15 INIT
EMPL: 201854 MS.gowtham 17) 4-Feb-15 5-Feb-15 2 MED LVP Mar-15
EMPL: 201854 MS.gowtham 18) 15-Feb-15 15-Feb-15 1 MED LVP Mar-15
EMPL: 201854 MS.gowtham 19) 9-Jun-15 9-Jun-15 1 MED LVP Jul-15
EMPL: 201854 MS.gowtham 20) 24-Aug-15 24-Aug-15 1 MED LVP Sep-15
EMPL: 201854 MS.gowtham 21) 13-Dec-15 12-Jan-16 31 ANN LVP Nov-15