Python Forum
Merge 2 Excel in a specific format
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Merge 2 Excel in a specific format
#1
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
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  How to properly format rows and columns in excel data from parsed .txt blocks jh67 7 1,802 Dec-12-2022, 08:22 PM
Last Post: jh67
  How to format Excel column with comma? dee 0 1,337 Jun-13-2022, 10:11 PM
Last Post: dee
  Converting cells in excel to JSON format desmondtay 4 1,685 May-23-2022, 10:31 AM
Last Post: Larz60+
  Need Help writing data into Excel format ajitnayak87 8 2,438 Feb-04-2022, 03:00 AM
Last Post: Jeff_t
  Exporting dataframes to excel without loosing datetime format Rafa 0 1,212 Oct-27-2021, 10:42 AM
Last Post: Rafa
Smile Set 'Time' format cell when writing data to excel and not 'custom' limors 3 6,200 Mar-29-2021, 09:36 PM
Last Post: Larz60+
  How to append a value to specific excel cell using openpyxl hobbyist 0 4,765 Mar-05-2021, 07:14 PM
Last Post: hobbyist
  merge excel pagara 1 1,545 Sep-11-2020, 06:53 AM
Last Post: scidam
  How to merge three DataFrames based on specific column Mekala 0 1,767 Sep-08-2020, 02:01 PM
Last Post: Mekala
  copy/pasting in excel WHILE keep file format zarize 0 1,918 Jun-23-2020, 03:51 PM
Last Post: zarize

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020