Relative Content

Tag Archive for google-apps-scripttranspose

How to automatically transfer row to a google sheet file, and transpose?

From the source file in A2, there’s the google sheet file via link where the row2: colB2:H2 will be assigned. Then, transpose it to sheet1 of B3:B9 of the destination file (located in A2). Can I apply the same pattern for the rest of the rows, like row3 to A3 file, then row3: col B3:H3, and tranpose it to sheet1 of B3:B9 of the destination file (located in A3).