Forum Discussion
Solved
Power query editor - Adding text and columns in one step
I need to add a new column to merge In Excel would be a formula = CONCATENATE ("Example:"; A2) Result: Data 1 Result 1 Text1 Example: Text1 Text2 Example: Text2 Text3 Example: ...
= [Column1] & [Column2]
You need to escape the text like in Excel like this:
"Example"&[Data 1]
= [Column1] & [Column2]