Best Online Learning Platform and Collect Information

Transpose with formula/Function


Transpose with formula/Function


Follow this steps

  1. Put your data in cell A1. 
  2. Put this formula in cell C1
  3. Adjust with requirement.( like you want to new row after 3 columns then put 3 replace 4  (*4 ) )
  4. Drag C1 right you  want to fill (its equal to *# values)
  5. 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
Share:

No comments:

Post a Comment

Follow by Email

Popular Posts