Python Forum

Full Version: Merge 2 Excel in a specific format
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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