https://www.extendoffice.com/documents/excel/1172-excel-transpose-multiple-columns-into-one-column.html oh magic single column formula perfect 2. After specify the range name, then click a blank cell, in this example, I will click cell E1, and then input this formula: =INDEX(MyData,1+INT((ROW(A1)-1)/COLUMNS(MyData)),MOD(ROW(A1)-1+COLUMNS(MyData),COLUMNS(MyData))+1).

https://www.extendoffice.com/documents/excel/1172-excel-transpose-multiple-columns-into-one-column.html
oh magic single column formula perfect
 
2. After specify the range name, then click a blank cell, in this example, I will click cell E1, and then input this formula: =INDEX(MyData,1+INT((ROW(A1)-1)/COLUMNS(MyData)),MOD(ROW(A1)-1+COLUMNS(MyData),COLUMNS(MyData))+1).
 

Leave a comment

Your email address will not be published. Required fields are marked *


× 9 = sixty three

Leave a Reply