AnsweredAssumed Answered

Combine data from different columns into one

Question asked by Imre... on Sep 6, 2013
Latest reply on Sep 6, 2013 by Imre...

Title

Combine data from different columns into one

Post

     Hello,

      

     I have a database with a number of columns which are, per client (PID), empty execpt one. (Data comes from another source)

     I'd like to move all data from the different "Module [kind]" columns into one "Module" column.

     The screenshot is perhaps clearer in showing what I would like to acchieve.

      

     The contents of the 6 columns on the right should all be moved to the one column "Module".

      

     How can I do this?

Schermafbeelding_2013-09-06_om_15.08.54.png

Outcomes