https://support.google.com/docs/thread/214279543/transpose-and-repeat-google-sheets-data?hl=en May 5, 2023 ... ... row(r) - row(data) + 1)))), table, offset(data, 0, 0, numRows), numColsToSqueeze, columns(table) - numColsToRepeat, headers, { offset(table ...