1 Reply Latest reply on May 10, 2013 3:56 PM by Shawn Wallwork

    Need help with calculated field

    Lisa Lacroix

      I have data in these fields:  Student Number, Semester Name, Period Number, and Course Name, For example:


      Student Number     Semester Name     Period Number     Course Name

      111222                    SEM1                    01                    Biology

                                                                  02                    English

                                                                  03                    Math


      How would I create a calculated field called SEM1/Period1, SEM1/Period 2, etc. that would put the Course name in the field so that my worksheet would look like this:


      Student Number     SEM1/Period1     SEM1/Period2     SEM1/Period3

      111222                    Biology               English               Math


      Thanks! Lisa