Unpivot same header

[ngiam]

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

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!

[ngiam · Accepted solution]

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!