Article updated on July 19, 2017

Question: How do I create a new list from an old list sorting out every second row?




Formula in F1:F10:

=INDEX($A$1:$D$20, ROW()*2-1, 1) + CTRL + SHIFT + ENTER

Formula in G1:G10:

=INDEX($A$1:$D$20, ROW()*2-1, 2) + CTRL + SHIFT + ENTER

Formula in H1:H10:

=INDEX($A$1:$D$20, ROW()*2-1, 3) + CTRL + SHIFT + ENTER

Formula in I1:I10:

=INDEX($A$1:$D$20, ROW()*2-1, 4) + CTRL + SHIFT + ENTER

Download excel example file.
(Excel 97-2003 Workbook *.xls)

Functions used in this blog post:

Returns a value or reference of the cell at the intersection of a particular row and column, in a given range

ROW(reference) returns the rownumber of a reference