I might have screwed things up even more I went and adjusted our site to make it easier to register, I also adjusted the school codes so it would be the correct format. I deleted a column that screwed it up.

Here is the new download format.

I only need the following

Name participants Last Name, Participants First Name
ID
Exp.
St
Gr School Grade
Team School
Rate
Local

I should have done this before. The only things I need are Participants Lane, First name in the name field, school grade in the GR field, and School in the team field (I adjusted our website, so It should be correct for our next event. All the other fields can be blank since my other program will add them in. However, even though they are blank, I need those fields to be in the sheet, or else my program will not read the file.

Apologies for making this so hard for you guys, and thank you for all the help

Attached Files

correct format.xlsx (10.8 KB, 7 views)