I'm making a script that will write a two-dimensional array to an Excel spreadsheet. The script is meant to be called from within other scripts. An outer loop runs once for every row in the array ...

I'm writing a script that creates a two-dimensional array based on user input and displays the array in a tabular format. ... The second part--displaying the array in rows and columns--is difficult.

Then, copy the array to complete the column (or row). Figure E. Array formulas are common in complex sheets, so I don’t recommend them for the average user; they require specialized knowledge that ...