Snasui Excel Forum

Hi dear,
I need your help how to write formula to unpivot data for data analysis.

I have attached a template with outputs as well.

Thanks

...

E2:Fxx

=IFERROR(INDEX($A$2:$D$4,INT(ROW(E3)/3),INT(COLUMNS($E2:G2)/2)+MOD(ROW(E3),3)*MOD(COLUMNS($E2:F2),2)),"")

Norkaz

Thank you