I want to get the same data in two consecutive fields in a column but when I pull the column down it skips the odd fields in the reference. How do I do this easily? There are several thousand fields from another tab.
b2 = name J2
B3 = name J2
b4 = name j4
b5 = name j4
Another option is
=INDIRECT(ADDRESS(ROW(C5)+INT((ROW($C$5)-ROW(C5))/2),COLUMN(C5)-1))
Note the reference to $C$5. This should refer to the cell at the top of the target range. It sets the starting point of your target range. Also, note the "-1" in the final argument. This should be the number of columns that the source range is away from your target range (-1 is one column to the left). Source and target ranges should start on the same row.
If the source range is on another sheet, you can add the sheet name to the formula as shown here. In this case, the source range is on "Sheet5" starting at J2 (hence the +7 in the last argument, since J is 7 columns to the right of C).
Accepted Solutions