Thread: [Solved] Split an excel file into multiple files based on a column's content
View Single Post
 
Old 07-03-2018, 10:33 PM
puff puff is offline Windows 7 64bit Office 2013
Advanced Beginner
  
Join Date: Apr 2017
Posts: 60
puff is on a distinguished road
Question Split an excel file into multiple files based on a column's content
Hi all! I have an excel sheet that contains lots of information and I want to split it into multiple excel files based on a column called "list #". I used string from "list 1" to "list 23" to label all those rows. I know how to do the job in python but it will be messier. Is it possible to split this file into 23 files such that each smaller excel file only contain the rows with the corresponding list number? Thank you XD
Reply With Quote