mod formula
1 Topic
Can someone explain how the below formula to transpose all rows to one column works?
Hello, I have used this formula: **=INDEX( MyData,INT((ROW()-ROW( $Z$1 ))/COLUMNS( MyData ))+1,MOD(ROW()-ROW( $Z$1 ),COLUMNS( MyData ))+1)** to transpose all of my rows of data into one column. Unfortunately, I can't entirely wrap my head around how it works. Would someone be willing to explain it to me? Any assistance is appreciated. Thanks, Anthony SmithSolved3.5KViews0likes1Comment