I need help.
I need to take files (csv, excel) have them and formatted them into a pre defined format. After the file gets formatted I need to create a report.
the input files are huge, 500,000+ records with 26 columns of data.
is there an easier way of dealing with this kind of data?
I can do this manually but it is taking me hours just to work on one file if excel does not crash.
Any ideas? Programs? anything?