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.
---------------------------------------------------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.
No comments:
Post a Comment