Conversion of column values to column name

[lucky7 (Vrishchiklucky)]

Hi All,

Name City
James Hyderabad
Mary Delhi
Peter Bangalore
John Mumbai
David Chennai
Rakesh Hyderabad
Gopal Bangalore
I want the second column values from city to become column name as below,
Name Hyderabad Delhi Bangalore Mumbai Chennai
if the column name is not exists then we need to create the column name if already contains skip creating that column

[yedukondaluaregala]

@lucky7

Can you explain little more about the process or if you some screenshots that will be more helpful to provide the solution

[lucky7 (Vrishchiklucky)]

My input is as below:

My expected output:

Based on the column values from city columns ,I need to create unique columns

[Parvathy (PS Parvathy)]

Hi @lucky7

Input:

Output:

Check the below workflow:
Sequence6.xaml (8.5 KB)

Hope it helps!!

[Yoichi]

Hi,

Can you try the following sample?

Sample
Sample20250310-2.zip (10.2 KB)

Regards,