#1
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Read multiple xml files in excel - Column names and Tag - Column alignment | sumshen | Excel Programming | 0 | 04-17-2017 12:55 AM |
Combine Different Word files into one file and update Table of Content | tejaspareek | Word VBA | 4 | 11-04-2014 05:50 AM |
Excel found unreadable content in file.xls. Do you want to recover the content of this workbook? | Sanfran | Excel | 2 | 10-21-2014 12:09 AM |
Insert values from multiple rows based on value in one column | pachmarhi | Excel | 3 | 07-18-2014 09:57 PM |
convert multiple csv files to multiple excel files | mit | Excel | 1 | 06-14-2011 10:15 AM |