Forum Discussion

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!

Copper Contributor

Aug 22, 2023

tauqeeracma it works fine. plz give the formula for multiple rows

Diamond Contributor

Aug 22, 2023

If on 365

=HSTACK(
    TOCOL(CHOOSECOLS(range, SEQUENCE(, COLUMNS(range) / 2, , 2))),
    TOCOL(CHOOSECOLS(range, SEQUENCE(, COLUMNS(range) / 2, 2, 2)))
)