#index command in excel,#transpose in excel
This is the simple Technique to transform a set of rows to columns.it is possible using index command.
Enter the formula into a blank cell b1,
for example, =INDEX($A:$A,ROW(A1)*5-5+COLUMN(A1)),
see screenshot:
Drag the formula toward the right side and for bottom cells.see the magic.
