Hi,

I generate 100-200s .csv files end of each month for my company.

Each of these .csv files have numerous data that I need to sum up for a
report.
(Example: 1.csv have 3 columns with things like, item A, item C, item D etc
and 2.csv have columns with item B, item C and item E... and so on and so on)

I am required to sum up all these 100-200s .csv files and have a total sum
of how many of each items appeared and used by the users.
(Example: item A - total count 100, item B - total count 20.. .etc etc)

Is there a way I could do it without going through each of the .csv files
and counting them manually?

The number of columns and the number of name of the items (the same name for
each item are in used) are not fix in each .csv files.

Could anyone please help me with a solution?


Regards,
Lee