Combine row values to make it as column title

Question

Hi Team,

I have a column named as "Title" and entries in the column as a,b,c,d,1,2,3,4.

Now what I need is, I need to combine a,b,c,d and make them as title of the respective column.

Please help me on this issue. I have attached sample input & expected output

Sample input & output.xlsx

Qiu · Accepted Answer

@Gsiva3

From what I know, the multi line Field name is not allowed in alteryx.

So we have to export it to something, such as Excel.

Qiu · Accepted Answer

@Gsiva3 
I am going to ask for two accept mark then.😁