I have this csv
file, formatted like this one:
Store,Product 1,Product 2,Product 3,Product 4,Product 5,Sub Total Store 1,15,99,299,75,292,780 Store 2,33,353,429,283,561,1659 Store 3,248,381,403,306,454,1792 Store 4,3,14,42,2,32,93 Store 5,129,37,22,89,39,316 Store 6,147,396,404,221,441,1609 Store 7,1228,998,797,1008,1369,5400
I want to it to be formatted like the one in the figure.
Because the csv
file is provided as-is and will be loaded dynamically. Is it possible to do that kind of work, just using the datatool
without re-format the csv
? (e.g. re-format using Excel, then export to new csv
file).