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
Help Article Resources
Check out the Formula Handbook template!