I have a (probably) simple problem but could not solve it for the life of me. I need to copy 2-dimensional array from one sheet into a single column on another sheet.
Example:
Sheet1, data is in a range C2:N225
needs to be copied (transposed) onto
Sheet2, in a range D2:D2680
> First row of the array (Sheet1!C2:N2) goes into Sheet2!D2:D14
> Second row (Sheet1!C3:N3) goes into Sheet2!D15:D27
> ... and so forth
Many thanks!
Bookmarks