MS Query Concatenation

[alanmweb]

Hello, I am working on joining two tables together, and need to concatenate two columns together before joining. I'm using Excel->Get Data->From Other Sources->From Other Sources->From Microsoft Query. After that I've been using the manual SQL view to join tables. I haven't seen this question, so it would be nice to know if its possible, or if I need to switch programs.
Thanks,
Alan

 

[EFANYoutube]

Can you be a bit more spacific.
When you say "Join 2 tables together" do you mean to "INNER/OUTER JOIN" or do you want to "UNION/UNION ALL"?

 

[alanmweb]

Can you be a bit more spacific.
When you say "Join 2 tables together" do you mean to "INNER/OUTER JOIN" or do you want to "UNION/UNION ALL"

Turns out I didn't need to concatenate. I just made a connection in power query, and used textjoin to join the two columns. Thanks, your response helped me solve it.