Forum Discussion
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 Apples Orange Strawberry Apples Orange Mango ...
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!
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!