Merging repeating values up by removing empty values
I want to remove all empty values and move the rest of the data up in a repating field.
Field 1 = (Grade Level) (Text 30 repeats) = Pop up menu with the following list values (3,4,5,6)
Field 2 = (Student First Name) (Text 30 repeats)
Field 3 = (Student Last Name) (Text 30 repeats)
Field 4 = (Student Name) (Claculation 30 repeats) = Student 01 First Name & " " & Left ( Student 01 Last Name ; 1 )
Field 5 = (Grade 3 Workout) (Calculation 30 repeats) = If ( Grade Level = 3; Student Name; "")
The data is
3 John Smith JohnS
4 Mark Ward MarkW
3 David Mann DavidM
4 Peter Kemp PeterK
3 Alan Rutter AlanR
The problem I have is field 5 generates the following
How do I get it to look like this?
Edit: For some reason I forgot all about the list function.
I knew I would get it as soon as I posted this.