ODBC guide

Update values vertically (column mode)

Writes values vertically (by columns) instead of across a single row. Use MajorDimension='COLUMNS' so each column in the SET list becomes a column of values starting at the specified cell.

UPDATE [My sheet]
SET Column1='Jan', Column2='Feb', Column3='Mar'
WITH(
  WriteRange='G9',
  SpreadSheetId='1az2H8ZYk7BvjddVTqPR-LfDjX9IRpIpjCDpFPe9EzkU',
  MajorDimension='COLUMNS'
)