We have an excel sheet full of player roster names, stats, events, and contact info that needs to be reformatted to match a new format for upload into a database. Currently, there are nearly 2000 entries. Attached is the old format sample and the new format.
First, Last, and Email must be repeated to avoid duplicates. The final dataset must be provided as a .CSV file.