Monday, February 14, 2011


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

macattack2401 said ...
How can I produce a sheet that doesn't have any empty cells.
I want each row just to show the actual entries that people have made. LIke a summary sheet that we can process easily.
In the following solution I used the concat operator '&' and the split function ... one formula should do it all, but because of a quirk in the split function where only first cell of the first row gets populated, I had to use one more formula in the second cell of the first row as delineated in the Summary sheet.