I have problem in reading cell with multiple values and comparing the each value with column from a-z if match found then set value of the cell has '1'.
Problem: I need to take multiple company names in the list and take one company and look for the same in the columns if match is found then set the value as
1 and read each consecutive columns.
Please find a sample spreadsheet: sample sheet. Currently I'm learning Google scripting so I need your help.