Rename and Merge Headers

[ManuelRodrigues]

Hi Folks,

I have data in the columns highlighted in red below and i am trying to get to rename the columns and merge all the data in the new [Name_New] column created via dynamic rename. unfortunately i have had no joy with this expression:

IIF(CONTAINS([_CurrentField_],'Traveller Name'),'Name_New',[_CurrentField_])

Thanks!

[KarolinaRoza]

hi @ManuelRodrigues 

I think here you can use Formula tool to create new column:

 and then Select to deselect old ones.

Karolina

[ManuelRodrigues]

thanks @KarolinaRoza I think that would concatenate the columns whereas i want to stack them one on top of each other [sorry if that was not clear]. i could union them but i have a few of these and that would be too much.

[MatthewBr]

Why don't you use a dynamic rename tool?