Transpose A Range Of Cells Using Formula

[mahmoud-lee]

I want a formula that converts rows to columns

[patel]

This is not a simple transposing, you need vba, but you don't like it, why ?

[Admin]

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))

[mahmoud-lee]

Thank you very much, wonderful solution