Forum Discussion
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!
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
tauqeeracma it works fine. plz give the formula for multiple rows
If on 365
=HSTACK( TOCOL(CHOOSECOLS(range, SEQUENCE(, COLUMNS(range) / 2, , 2))), TOCOL(CHOOSECOLS(range, SEQUENCE(, COLUMNS(range) / 2, 2, 2))) )
