I have raw data having many columns that is summarized in a pivot table similar to the one shown below. Now, I need to create a new files for each of the row label .
Row Labels20012002Grand TotalJan22Feb1010Mar88Apr5954113May55
Ex: The first file would be Jan_2001, that contains 2 records. Second will be Feb_2002 that contains 10 records.
I have the pivot with 750 such data points, and hence need 750 files. PLease advice if I can automate this.
Appreciate your guidance and support.