How to dynamically combine and rename 2 or more columns to one

[rochelleumel]

Hello everyone.

I have multiple files with different field names and trying to combine all columns to one. 

For reference, this is the sample after loading all files

I want it to be like this

Note that I have 50+ fields and it's hard to do the formula tool again and again just to combine all fields.

I tried to use the dynamic rename and this is what it gave me

Would appreciate all your suggestions. Thank you
 

[OTrieger · Accepted solution]

@rochelleumel 
It might be the most efficient way, but it is simple is you have only basic knowledge in Alteryx.

Add record ID, that will enable you to group the values and the dates.
Transpose the data
Use Summarize tool to concatenate the data, grouping on recordID
Text To Columns
Select tool to remove what is not needed and renaming

[OTrieger]