AnsweredAssumed Answered

Merging repeating values up by removing empty values

Question asked by WilliamNoble on Apr 12, 2012
Latest reply on Apr 12, 2012 by WilliamNoble

Title

Merging repeating values up by removing empty values

Post

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

-JohnS

-

-DavidM

-

-AlanR

How do I get it to look like this?

-JohnS

-DavidM

-AlanR

Capture_01.PNG

Outcomes