Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
tables in Excel
#1
Hi,

I have an Excel workbook with two sheets, called "Sheet1" and "Sheet2" with both 2 columns and 4 rows of data. They also have column headers. I would like to have a python script that creates a new sheet named "Sheet3" that puts the data from both sheets in a table that can be filtered and sorted. The tables should be sorted on age from low to high.

Any input is much appreciated!

Attached Files

.xlsx   Map1.xlsx (Size: 10.57 KB / Downloads: 124)
Reply


Messages In This Thread
tables in Excel - by MaartenRo - Jan-06-2024, 06:35 AM
RE: tables in Excel - by Pedroski55 - Jan-06-2024, 06:58 AM
RE: tables in Excel - by sgrey - Jan-06-2024, 07:26 AM
RE: tables in Excel - by deanhystad - Jan-06-2024, 03:46 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Python script to summarize excel tables, then output a composite table? i'm a total n surfer349 1 3,254 Feb-05-2021, 04:37 PM
Last Post: nilamo
  Excel tables and move rows jdos 6 5,993 Jul-02-2020, 05:52 AM
Last Post: jdos
  Write tables from Word (.docx) to Excel (.xlsx) using xlsxwriter jackie 1 4,066 May-27-2020, 11:47 PM
Last Post: mcmxl22

Forum Jump:

User Panel Messages

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