How to consolidate a document that has blanks



I have a grid I stored comments on questions from customer. some question may not have been answered so it results in the cell being blank.

I would like to get to another document where all the available answers are consolidated, with no blank cells.

Below a screenshot of an example document.

so ideally I would like to end up in a situation like the below

Any idea?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!