Forum Discussion
abellanc
2 years agoRegular Visitor
Combine Column B and Column A with Column A inside a parenthesis
I want to combine Column B and Column A with Column A in parenthesis. I tried text.combine and concatenate but I cannot make it work. Input A B Dog Tic-Tac Cat Willow Cat Junior ...
- 2 years ago
Table.ReplaceValue(Input, null, (x) => " (" & x[A] & ")", (v, o, n) => v & n, {"B"})
AlienSx
Super User
2 years agoTable.ReplaceValue(Input, null, (x) => " (" & x[A] & ")", (v, o, n) => v & n, {"B"})