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

    Merging Columns and Combining Data

    Syneos Health

      Hi,

       

      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:

       

      MERGED COLUMN

      Rows:

      Mood 5

      Mood 4

      Mood 4

      Mood 6

      Mood 5

      etc.

       

      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.