Forum Discussion
Need Help
Hi All I have a two text columns in the table, but i need to combine the two text columns make it as one in power Query Below are the examples in the below table i have Name column and New Name ...
Anonymous
Please clarify the logic by adding a few more rows in the sample. I only see the result = column2. For now, you can also try:
= if Text.Contains([Column1],[Column2]) then [Column2] else [Column1]
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.