Excel-Buzz

Hello Everyone, So here is the situation.. As you can see, I am arranging data from array or table into a list..  Actually this can be done with two different formulas based on similar kind of approaches… Now first we will take INDEX Function Approach… The formula used is.. =INDEX($A$1:$C$4 , 1+INT((ROWS($D$1:D1)-1)/3) , 1+MOD(ROWS($D$1:D1)-1,3)) Table Row No. Column No. Actually, the trick lies in calculating Row and Column No. Based on the TABLE INDEX we have used.. I.e. $A$1:C$$4, we have to use following Row and column No's Row No. Column No. 1 1 For Row no., I have used <---- 1 ...