Hi there

I have an excel sheet, simplified version below, with 7 columns each with one row containing data and the rest blank. How do I return the non-blank values from each row in the right hand column?

2018-07-09 17_11_38-Return Non Blanks - Excel.png

Thank you!

Clare