Get list of borrower numbers (not barcodes) in Analytics


Add comma to all cells by

Add =A1&"," to next column for each row 

Copy that new column into a third column as the “value”


Copy to Notepad to lose hidden formatting

In Sql - 

Update borrower set grad_year=’2107’ 

Where borrower# in (#####,####)


May need to change to SQL single quotes rather than the google quotes


Copy and paste all borrower numbers from Notepad between the parenthesis

Run the query to update the borrower grad year.