Copying data from every nth column to a new column-CodePudding

i have a sheet with data in i4,i11,i18,i25 etc; besides this data in every 7th cell of column i starting at i4 all the other cells in i column are blank(there is data in other columns i.e."a-h") I would like to copy the data from these cells in column i starting at i4 then every 7th cell in a new column n that has the data starting in n2. I have tried an example I found here with a list of names with to solutions and can't get either to work.
=filter(I4:I, mod(row(I4:I) 1,7)=0) =offset(I$4,7*(row()-1)-2,)

Thank you!

CodePudding user response：

=QUERY(I4:I,"select * skipping 7")

The following should also work for your case

=QUERY(I2:I,"select * where I is not null")

CodePudding user response：

it should be:

=FILTER(I4:I, MOD(ROW(I4:I) 3, 7)=0)