Combine Column B and Column A with Column A inside a parenthesis

[abellanc]

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)

[abellanc]

Mindblown... Thanks, it works like a charm!!!

[AlienSx · Accepted solution]

Table.ReplaceValue(Input, null, (x) => " (" & x[A] & ")", (v, o, n) => v & n, {"B"})