Create a Macros that would create seperate file with data based on a given coloum Name
Budget: ₹600 – ₹1,500 INR
Supose there is a file with many headers and each have data in it
There is a coloum A which has value so based on those values seperate files are created along with the header
The file name is the name of the value in it, if the coloum is blank that is not consider in the output
Attached is a sample example with the input and the desired output and also the explaination
Please note this is just a sample the actual data will have few 100 coloums and upto 50000 rows
Please apply if you are ready to deliver this today
There is a coloum A which has value so based on those values seperate files are created along with the header
The file name is the name of the value in it, if the coloum is blank that is not consider in the output
Attached is a sample example with the input and the desired output and also the explaination
Please note this is just a sample the actual data will have few 100 coloums and upto 50000 rows
Please apply if you are ready to deliver this today