Copy multiple rows and transpose to one row

Hi!

I am trying to copy multiple rows of a spreadsheet and transpose them into one column of another spreadsheet. I know how to do this one row at a time, but is there a way to copy multiple rows at a time? Thanks!

There are 115 rows that need to be transposed into one column. Each row has numbers in them that expand from column A to U.

Example: numbers are in rows 1-115 from columns A through U

Row 1: 0 1 4....
Row 2: 8 4 7....
rows filled with numbers from row 1 to row 115
Row 115: 5 8 7....

and transpose them to column E of another sheet like this

E
0
1
4
8
4
7
.
.
.

5
8
7

Did I provide enough information?