I’m looking for ways to concatenate (I think) a row of two different columns to make a set of SKUs for our retail situation. The catch is that one of the columns often carries a couple different options in it, and I’m having trouble getting a single list that includes all the combinations of it.
Our SKUs are built from an abbreviation of what the Doodad we’re building is and the options that it takes on. For example we have both Orange and Pink Gizmos that have SKUs respectively of GizOrange and GizPink while Widgets come only in orange and only have WidOrange as a SKU. I’m looking for a way to create a list of all the SKUs automatically, ideally one that would be available for me to draw upon later when making invoices etc with a lookup column.
Any help that could be offered would be huge! Thanks so much.