Formula to reorganzie data in tabular format

[rizmomin]

Hello:

Please refer to attached file.
I have data as shown in Range(J1:V16)

I need formula in cell J2:M down to give data in tabular format as shown.
Hoghlighted just for clarification.

Let me know if you have any questions.
Thanks.

Riz

[Special-K]

J34 should be Feb18 not jan 18

[rizmomin]

Hello:

Yes you are right, it was typo

Thanks to point it out.

Ri

[Glenn Kennedy]

Month:
=INDEX($K$3:$V$3,,1+INT((ROWS(J$22:J22)-1)/12))

Storename:
=$J$1

Item Desc:
=INDEX($J$5:$J$16,1+MOD((ROWS(L$22:L22)-1),12))&""

Total:
=IFERROR(1/(1/INDEX($K$5:$V$16,1+MOD((ROWS(M$22:M22)-1),12),1+INT((ROWS(M$22:M22)-1)/12))),"")

[Special-K]

in J22
=INDEX(K$3:V$3,QUOTIENT(ROW()-22,12)+1)

in K22
=$J$1

in L22
=INDEX(J$5:J$16,MOD(ROW()-22,12)+1,1)

in M22
=INDEX(K$3:V$3,QUOTIENT(ROW()-22,12)+1)

copy the formulas in row 22 downwards

[rizmomin]

Hello:

Thanks Guys

Riz