Transpose with formula/FunctionFollow this stepsPut your data in cell A1. Put this formula in cell C1Adjust 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...

Search Operators(Creat your own custumize search qu...