I am trying to build a variable data report in Adobe Illustrator. This report will have graphs and data for each individual listed in an excel/csv file. To be able to generate the graphs there needs to be a .csv file of the data only pertaining to the graph relevant to that specific individual.
So for example I have three individuals: John, Joe, and Ann.
Each individual will have a bar graph showing their growth in communication, and they will also have a graph showing their growth in confidence.
Each individual needs a csv for both graphs. Which means I will need a total of 6 csv files to start building the variable data report in excel.
Obviously all of the data will be together in one excel file that I will need to separate out and save as the individual csv files.
Is there a script I can use that will export each row (representative of the individual) as it's own separate csv file and name it based on the data in cell A2 and B1?
I have done some research and I have found some solutions that only reference the columns or how to export selected rows, but I will need to do this for 100+ individuals and these solutions will not work for the volume I need them to. I am somewhat familiar with VBA coding, but I am having a hard time finding anything that can help with this issue.
So if my cells look like this:
A B C
1 Name Communication Communication End
2 John 20 25
3 Joe 16 18
4 Ann 23 27
My file names will look like this: John_Communication.csv, Joe_Communication.csv, Ann_Communication.csv
And will only export the data from each individual row as it's own csv file so that I can import the data into Adobe Illustrator to create the graphs I need for the individual's reports?