I need a quick formula to read from several columns in excel (actually google sheets) and form a string of text. The sheet is here: [url removed, login to view]
and for instance, I need a comment in column Xin tab MPE01, cell X8 needs read other column data in that row and show: silty sandy GRAVEL: poorly sorted, loose, grey with light brown fines. Roadbase. FILL.
cell X9 needs to be: silty CLAY: poorly sorted, med plasticity), light grey and brown. FILL. Then it should work for all other rows from X7 down to X17.
It is a simple job I could do myself, but I am flat out. If you can do it , it needs to be in the next 20 minutes