Hi ,I am new here,so here goes.I have about 100 csv files containing data.
eg as follows:
Devicename Username Faxes Copies Pagecount Department
HP4100 KING 20 500 1000 sggt100
HP4100 queen 20 500 1000 sggp400
I need to collate this data in one excel worksheet by the different devicenames broken down by department and pagecounts by user.
Can anyone please assist.
Thanks
eg as follows:
Devicename Username Faxes Copies Pagecount Department
HP4100 KING 20 500 1000 sggt100
HP4100 queen 20 500 1000 sggp400
I need to collate this data in one excel worksheet by the different devicenames broken down by department and pagecounts by user.
Can anyone please assist.
Thanks