Combining 2 excels into 1 output

[gavinloi_]

Hi all, I am stuck while creating a workflow where I would have 2 excels (1 with the data and another master template where the data would be pasted to).

I would require to paste the data at another column however I am currently stuck at the step that merges the 2 excels.

Any help would be kindly appreciated. Thank you

Excel with data (Names (data).csv)

Master Template (Name Template.csv)

Final Output (Output Template.xlsx)

[aatalai · Accepted solution]

Hi @gavinloi_ 

If my understanding is right you start with 

Excel with data (Names (data).csv) and want to add country of orgin and citezenship columns (blanks)

If this is correct. Then use a data input tool with (Names (data).csv  then add a formula tool with the headers you desire, and use a select tool to put it in the order you want 

Let me know how you get on/if my understanding is correct.

Ta

[gavinloi_ · Accepted solution]

Hi @aatalai thank you so much, that works wonders and I included a select function as well to help. Many many thanks! 

[aatalai]

@gavinloi_ glad I could help can you please mark that as solved/the solution when you get a moment