Forum Discussion
Solved
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 |
| Cat | Prince |
| Dog | Barney |
Output
| A | B |
| Dog | Tic-Tac (Dog) |
| Cat | Willow (Cat) |
| Cat | Junior (Cat) |
| Cat | Prince (Cat) |
| Dog | Barney (Dog) |
Table.ReplaceValue(Input, null, (x) => " (" & x[A] & ")", (v, o, n) => v & n, {"B"})
