Convert row to column and pivot

Question

I have data like this

I want to convert this data as below

How could we achieve this in alteryx? Thanks

T_Willins · Accepted Answer

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 Answer

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 Answer

Thank you. It worked

MaliniLakshman · Accepted Answer

Thanks a lot. It worked.