Forum Discussion

grantmcyorku's avatar
grantmcyorku
Copper Contributor
Dec 23, 2021

Help Transposing every 2 Columns to Rows

Hoping someone can help me out.  I'm looking for an automated way to transpose every 2 columns to rows.   I want to go from this: To this: Thanks!  
excel
Formulas and Functions
tauqeeracma's avatar
tauqeeracma
Steel Contributor
Dec 23, 2021

Hi grantmcyorku 

 

You may use the below formula based variant to transpose columns to rows:

 

Formula for Column_1 >>>>    =OFFSET($D$2:$S$2,0,((ROW(B5)-ROW($B$5))*2),1,1)

Formula for Column_2 >>>>    =OFFSET($D$2:$S$2,0,1+((ROW(C5)-ROW($C$5))*2),1,1)

 

A sample file is also attached for your reference.

 

Please let me know if it works for you.

 

Thanks

Tauqeer

Resources