Dynamic columns to rows

Amit_Rastogi

How achieve this.. Pls help 
Input file:

Col A	Col B	Col C
US,NYC,CA	IN,AF	CA

I want to add dynamic feature when user choose Col A then output looks like

Output

Col A	Col B	Col C
US	IN,AF	CA
NYC	IN,AF	CA
CA	IN,AF	CA

When user choose Col B then output looks like

Output

Col A	Col B	Col C
US,NYC,CA	IN	CA
US,NYC,CA	AF	CA

Thanks in advance,

shreyanshrathod

Hi @Amit_Rastogi ,

Hope this can be a good starting point for your query.

I have populated the LIST values in the DROP DOWN Interface manually for now. You can configure as per your requirement.

Regards,

Shreyansh Rathod

Dynamic colums to rows.yxwz