Combine row values to make it as column title

[Gsiva3]

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

[Qiu · Accepted solution]

@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.

[Gsiva3]

Thanks for the solution @Qiu 

My one more concern is, I need to apply this solution for all the columns in the file. I have around 40 columns for which the same thing has to be done.

Please provide solution for this.

[Qiu · Accepted solution]

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

[Gsiva3]

Thank you so much @Qiu .

Its working now.

And I am giving you 2 accept marks😊