7 Replies Latest reply on Feb 14, 2019 6:53 PM by Prasanna R

    Merging Columns and Combining Data

    Syneos Health



      I have 8 columns that I'd like to combine into one, but as part of the merge, I would like to replace the word "Like" found within the rows with the name of the Column heading.


      I know this is a bit complex, but maybe someone has dealt with this before. Please see the attached image for clarity.


      Based on the screen shot, the result should look like this:




      Mood 5

      Mood 4

      Mood 4

      Mood 6

      Mood 5



      If anyone has an idea, I would really appreciate it!


      Also - The Pivot option for this table is not available; doesn't show up in the drop down.