10 Replies Latest reply on May 21, 2018 8:20 AM by Bryce Larsen

    Create a new field combining two fields


      There is a field called Subject which has three values, History, Science and Geography, and each of these subjects has the Student IDs of students taking the course and the language that they speak, and also total overall marks of each student.


      Now, I have a scenario where, a particular subject can get merged with another subject. For example -> Science can now be combined with History.


      I want to a new worksheet which shows both as one and show the combined details of the two subjects as one.


      I have created 2 fields , Old Subject and New Subject, to indicate that the Old subject get combined with new.


      Is this possible?