Need to fill data while keeping blank row in between

It seems like you’re trying to copy data from one sheet to another in Excel, but you want to skip the blank rows in the new sheet. Here’s a way to do it:

Create a helper column: In your original sheet, create a new column next to your data. In this column, for each row, put the row number (you can use the ROW() function for this).

Use INDEX and MATCH in the new sheet: In your new sheet, instead of directly referencing the cells from the original sheet, you can use a combination of INDEX and MATCH functions. The INDEX function returns the value of a cell in a given range, and the MATCH function returns the position of a value in a given range.

Here’s an example formula you can use in your new sheet:

=INDEX(OrigSheetName!$B$1:$B$1000, MATCH(ROW(A1)*3-2, OrigSheetName!$A$1:$A$1000, 0))

In this formula:

OrigSheetName!$B$1:$B$1000 is the range in the original sheet from which you want to pull data.
ROW(A1)*3-2 generates a series of numbers 1, 4, 7, etc., as you drag down the formula. This helps to skip two rows for each data point.
OrigSheetName!$A$1:$A$1000 is the helper column in the original sheet that contains row numbers.
Please replace OrigSheetName, $B$1:$B$1000, and $A$1:$A$1000 with your actual sheet name and ranges.