formula to copy every 7th row into new data set

Need to copy data from another set of data on the same sheet. Need to copy every 7th row. I don't want to do a copy & paste special. I want the pasted data tied to the original source and I am transposing when I paste. I have 365 cells of data and don't want to + each cell. Hope this makes sense. Help please!

Try something like:

=INDEX(A$2:A$365,7*(ROWS($A$1:$A1)-1)+1)

where A2:A365 contains the first column of data to extract from.

You may need to adjust the 7 to 6 if the extracts are off by one... (not sure what exactly you meant by every 7th row)

You can copy down and across, and you can wrap an IFERROR() around the formula to avoid errors when copying too far down.

THANK YOU!!! I read so many over things that were WAY over my head. You kept it simple. thank you!!