Forum Discussion

ngiam's avatar
ngiam
Helper I
4 years ago
Solved

Unpivot same header

Hi All,

 

I have the following headers. This is due to the logic that I applied during data collection stage through survey monkey

ApplesOrangeStrawberryApplesOrangeMango
      

 

When I unpivot, I get the below attached

 
Apples_1
Orange_2
Strawberry
Apples_3
Orange_4
Mango

 

How do I unpivot to get the following?

 
Apples
Orange
Strawberry
Mango

 

Thank you in advance!

Need Help
  • ngiam's avatar
    ngiam
    4 years ago

    I found the answer to my own question.

    1. Select column.

    2. Go to Add column.

    3. Select "Extract" then "Text before delimiter"

    4. Indicate "_" into the menu and it's done!

     

1 Reply

  • ngiam's avatar
    ngiam
    Helper I
    4 years ago

    I found the answer to my own question.

    1. Select column.

    2. Go to Add column.

    3. Select "Extract" then "Text before delimiter"

    4. Indicate "_" into the menu and it's done!