Transpose with formula/Function
Follow this steps
- Put your data in cell A1.
- Put this formula in cell C1
- Adjust with requirement.( like you want to new row after 3 columns then put 3 replace 4 (*4 ) )
- Drag C1 right you want to fill (its equal to *# values)
- Drag down to run formula to whole sheet.
Formula=
=OFFSET($A$1,(ROW()-1)*4+INT((COLUMN()-3)),MOD(COLUMN()-3,1))
Click here to download sample file Transpose with formula_Fuction
Go to Microsoft support website to Learn more
