How Can I combine Range in a Cell with Comma Separate Value (CSV) without write one by one Cell Name ? I Use Concatenate formula, but it does not work because I can't add Comma to separate every Cell Value. Anyone can help how to make formula with just write Start colom and Finish colom ? Is this the sample, start colom was 'P' and finish colom was 'AC'.
- My range ('P'+rowNo+':AC'+rowNo) -.
Script sheet.getRange(rowNo,colRekapSiswa).setFormula('P'+rowNo+'&","&Q'+rowNo+'&","&R'+rowNo+'&","&S'+rowNo+'&","&T'+rowNo+'&","&U'+rowNo+'&","&V'+rowNo+'&","&W'+rowNo+'&","&X'+rowNo+'&","&Y'+rowNo+'&","&Z'+rowNo+'&","&AA'+rowNo+'&","&AB'+rowNo+'&","&AC'+rowNo);

