How to consolidate a document that has blanks

Options

Hi,

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!