1 Reply Latest reply on Apr 12, 2012 11:23 PM by WilliamNoble

    Merging repeating values up by removing empty values

    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