Index and Match to return match with non-blank cell


We have product lists, sometimes the description for a product is 20+ lines long. I'm trying to get the important items, such as fire rating to float to the top of those 20 rows.

In the example below all of the rows highlighted in yellow are for one product. I'd like to get the Fire Rating data to pull into the same row as the Cost Line Item. Index and match is only returning the first cell in the fire rating column, which is blank. I'd like to use Index and match with COUNTA, but that isn't an option in smart sheet.

Any help would be greatly appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!