Concatenate cell/variable values to itself

Here is how I would solve this:


You can then cleanup (replace spaces, lowercase, etc.) your new “product types” either after unpivoting, or after the final concatenation.

2 Likes