I need to copy a range from the sheet 'Source' to the sheet 'Database' but transposed. It should be the range B1:T9, not the whole sheet. I need to do it with a script as it is going to be a database collected from many reports.
Here is the link Example sheet
Any ideas how to do it as I didn't find workable code examples for this case