How to concatenate the contents of two columns into a third using an "and" separator?

How to concatenate the contents of two columns into a third using an “and” separator?

Example:

Column 1 = Paper
Column 2 = Towel
Column 3 = Paper and Towel

image

Use the Template column.

4 Likes