Transpose Multiple Rows into single column

brandon16

Board Regular
Joined
Sep 29, 2014
Messages
122
Hi,

I have a range B2:Y194 of which I need to transponse from a row into a single column in cell A196, How would I go about doing this please?
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,341
in Sheet2!A196
=INDEX(Sheet1!$B$2:$Y194,QUOTIENT(ROW()-196,24)+1,MOD(ROW()-196,24)+1)
and copy down the column
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,096,247
Messages
5,449,238
Members
405,560
Latest member
Jadax

This Week's Hot Topics

Top