Hello Experts,
I have a excel sheet with 64k records i need to separate those datas into separate CSV files based on unique entries in certain column.
For Example:
In column H i have entries like
a
a
b
a
c
b
c
Then i need entries of a in separate csv file, b entries in another csv file and c in another csv file.
Note: need to copy data of row entries to csv files.
Is there any macros or formula as we need this for daily work to separate the file to csv and import the data to the tool.
Appreciate your help
Thank You
Pratham
Bookmarks