Convert row to column and pivot

[MaliniLakshman]

I have data like this

I want to convert this data as below

How could we achieve this in alteryx? Thanks

[T_Willins · Accepted solution]

Let me know if this works for you.  Looks like this is just a sample of your data, so the parsing of the text for the Drug Type field may need to be modified depending on the questions in field F1.

[fmvizcaino · Accepted solution]

Hi @MaliniLakshman ,

Attached is an example showing how to do it.

Take a look and let me know if this makes sense to you.

Best,

Fernando Vizcaino

[MaliniLakshman · Accepted solution]

Thank you. It worked

[MaliniLakshman · Accepted solution]

Thanks a lot. It worked.