Hello,
I have a spreadsheet with records of SKUs. Each SKU has a “Sales description” which is compiled of certain characteristics of the item. For example: dimensions, category, finish, etc.
Some of the items do not use each characteristic and in creating a template, I’ve found that extra whitespace is filled in wherever a characteristic is empty.
How can I structure my spreadsheet so that if a characteristic is empty, an extra whitespace is not generated and only leaves one space in between each entry to create a final templated cell.