I have a CSV file that contains student attendance records for classes in several learning centers across the state. The problems is that each row contains up to 25 attendees (students) per row.
I need to transform that file into a new CSV file. The new one would have a row for each student. So, if the original file had one row that contain attendance information for 25 students then my new file (table) would contain 25 rows. Each row having the attendance record for just one student.
Also, I need to automate this transformation so that it is easy to do and only requires a button click or something equally as simple. I thought about using using Excel or Access but I am not sure that is the best solution.
My question is, what is the best software application solution to use for the transformation?
Your feedback is much appreciated!