Forum Discussion
DemingPDCA
3 years agoHelper II
Create a string that "compounds" based on conditional statements
I need to create a string that compounds based on if there is a value in the column. I have a table that has a different column for each course (if they have completed the course there is a ...
grandtotal
3 years agoResolver III
DemingPDCA , you need to unpivot the course columns.
Check out this:
The best way may be the 'unpivot other columns' option: select the non course columns and unpivot other.