I want a formula that converts rows to columns
Printable View
I want a formula that converts rows to columns
This is not a simple transposing, you need vba, but you don't like it, why ?
Hi
In E12 and copied down,
=IF(ROWS(E$12:E12)<=COUNTA(DataTable)+COUNTBLANK(D ataTable),INDEX(E$3:E$6,INT((ROWS(E$12:E12)-1)/COUNTA($G$2:$J$2))+1),"")
F12:
=IF(E12="","",INDEX(F$3:F$6,INT((ROWS(E$12:F12)-1)/COUNTA($G$2:$J$2))+1))
G12:
=IF(F12="","",INDEX($G$2:$J$2,MOD((ROWS(G$12:G12)-1),COUNTA($G$2:$J$2))+1))
H12:
=IF(G12="","",INDEX(DataTable,INT((ROWS(E$12:E12)-1)/COUNTA($G$2:$J$2))+1,MOD((ROWS(G$12:G12)-1),COUNTA($G$2:$J$2))+1))
Thank you very much, wonderful solution