Leith,

Yes, that is correct. the output range needs to adjust depending on the number of rows.

the sheet that I'm trying to use this script on has some rows that contain 8 columns and some rows with data in 25 columns. I submitted the "sample" spreadsheet to convey the idea of what I was trying to accomplish. The sheet that I have has over 2,000 rows of data with variable number of columns for each row.

Hope this helps and I really appreciate your efforts.