Jan-16-2019, 07:26 AM
hi i am new python begineer need some suggestion to merge two excel
excel 1
Emp name Emp salary Emp age Emp dept
John 1000 25 works
Sam 2000 26 Plant
Tara 3000 27 finance
Jack 4000 28 Account
excel 2
Emp name
Sam
Jack
Result excel
Emp name Type Value
Sam Emp Salary 1000
Sam Emp age 25
Sam Emp dept works
Jack Emp Salary 4000
Jack Emp age 28
Jack Emp dept Account
excel 1
Emp name Emp salary Emp age Emp dept
John 1000 25 works
Sam 2000 26 Plant
Tara 3000 27 finance
Jack 4000 28 Account
excel 2
Emp name
Sam
Jack
Result excel
Emp name Type Value
Sam Emp Salary 1000
Sam Emp age 25
Sam Emp dept works
Jack Emp Salary 4000
Jack Emp age 28
Jack Emp dept Account