Combine data from different columns into one
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?