In excel, I want to implement that if Col1 is C, then the output column would be defaulted to ‘Not applicable’.

If Col1 is A, output column would be the formula = CONCATENATE(Col2, Col3).

If Col1 is B, output column would be the formula = CONCATENATE(Col3).

How can I do this with over a thousand lines of rows?