Combining Files Into one master file

Hello!

I'm wondering if there's a way for me to combine these files into two master files (One for sales and one for return)

Also, how do I combine the 3 columns into one? Let's say I want to combine: Mr. + Jon (First name) + Doe (Last name) = Mr. Jon Doe

I hope someone can help with this. Thank you

Workflow

Accepted answers

@rively90
These table appear to be normalized tables so we just need find the key column between each other then Join and Join

Below is a sample for the "Sales".

Combined Workflow.PNG

@rively90
there are a lot of files, can you identify which ones are the master files?

And to join columns we can simply use

'Mr. '+ [Jon (First name)]' ' + [Doe (Last name)]

@Qiu Hello!

I want to combine "Combine Sales and Container 15" Into one

Also

"Combine Return and Container 15" for the other 2.

So, 2 in total

@rively90
These table appear to be normalized tables so we just need find the key column between each other then Join and Join

Below is a sample for the "Sales".

Combined Workflow.PNG

thank you so much!

For the return tool container and container 15, do you know what should I do to combine those files?

Also, for the Initial + First and Last name, can we combine those columns in the formula tool? do we need to use CONCAT formula?

I know you're expert, thank you.