Copy multiple rows and transpose to one row [Closed]

Report
Posts
1
Registration date
Wednesday February 7, 2018
Status
Member
Last seen
February 7, 2018
-
 Blocked Profile -
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?

1 reply


Take a look here:
https://ccm.net/faq/54862-how-to-copy-data-from-one-excel-sheet-to-another-using-a-formula

Let us know if you get stuck after reading that!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!