The LET statement in this worksheet is courtesy of one of the community members.  I have tried pulling it apart and have had limited success.

Here is the ask.  There is one sheet that contains the base data.  The data is a list of products and their specifications.  In some cases, the specifications (cell) is empty and should not be included in the resulting spreadsheet.

The current resulting worksheet looks like this.  The rows (circled) should not appear as the value for the spec is blank “String,”

It should look like this.

I have attached the sample spreadsheet.  Hoping someone can help me out of this one.

​The LET statement in this worksheet is courtesy of one of the community members.  I have tried pulling it apart and have had limited success. Here is the ask.  There is one sheet that contains the base data.  The data is a list of products and their specifications.  In some cases, the specifications (cell) is empty and should not be included in the resulting spreadsheet.The current resulting worksheet looks like this.  The rows (circled) should not appear as the value for the spec is blank “String,” It should look like this. I have attached the sample spreadsheet.  Hoping someone can help me out of this one.   Read More

​