Excel Forum

Excel Magic Trick 650: Formula To Extract All Rows In Data Set Into 1 Column INDEX function

See an amazing formula to take all records from a data set and place them into one column. See the functions INDEX, INT, ROWS and MOD functions.

Got a Question? Ask it Here in the Forum.