Get horizontal data into vertical format using macro or formula

Hi All,
Greetings for the Day!
Myself Sukhdev Singh and stuck in a problem. I have a data in horizontal format (Sheet-1), and I want some specific data in vertically format (Sheet 2). Can anybody help me.

Sample Data in Sheet-1
S.No Emp Code Emp Name Branch DOB Matrital Status Rel Dependent1 Relation DOB Dependent2 Relation DOB DOJ CTC
1 8314 RAHUL KUMAR DURGANI INDORE 21-Dec-90 SINGLE Self 05-Feb-15 156000
2 8316 SHASHANK YESHWANT BEHERE PUNE 20-Jul-74 MARRIED Self AISHWARYA SHASHANK BEHERE WIFE 10-Sep-77 SAWANI SHASHANK BEHERE Daughter 04-Aug-06 17-Feb-15 720000
3 8317 RADHE SHYAM CHANDIGARH 25-May-80 MARRIED Self DALJEET KUMARI WIFE 17-Oct-83 HARSH Son 25-Oct-05 12-Feb-15 182400
4 8318 M. MOHAN HYDERABAD 29-Dec-80 MARRIED Self M. LALITHA WIFE 05-Sep-87 M. SAANVIKA Daughter 20-Sep-12 20-Feb-15 307200
5 8324 CHANDRESH MISRA HEAD OFFICE 02-Feb-79 SINGLE Self 02-Mar-15 1200000

Sample Data Format (Required) Sheet2
S.No Matrital Status EMP CODE NAME OF THE EMPLOYEE BRANCH RELATION DOB DOJ SALARY
1 SINGLE 8314 RAHUL KUMAR DURGANI INDORE Self 21-Dec-90 05-Feb-15 156000
2 MARRIED 8316 SHASHANK YESHWANT BEHERE PUNE Self 10-Sep-77 17-Feb-15 720000
AISHWARYA SHASHANK BEHERE WIFE 10-Sep-77
SAWANI SHASHANK BEHERE DAUGHTER 04-Aug-06
3 MARRIED 8317 RADHE SHYAM CHANDIGARH Self 25-May-80 12-Feb-15 182400
DALJEET KUMARI WIFE 17-Oct-83
HARSH SON 25-Oct-05
4 MARRIED 8318 M. MOHAN HYDERABAD Self 29-Dec-80 20-Feb-15 307200
M. LALITHA WIFE 05-Sep-87
M. SAANVIKA DAUGHTER 20-Sep-12
5 SINGLE 8324 CHANDRESH MISRA HEAD OFFICE Self 02-Feb-79 02-Mar-15 1200000


Thanks and waiting for your kind response.

Best Rgds,
Sukhdev Singh