I want to copy every 5th row starting from row 35 and paste it into a new sheet. Each row needs to be offset by 2 so that there is a gap between the newly pasted rows. I then need to average Every 3rd and 4th Row and paste it after every 5th row.

Put simply, here are the first few rows (only first column included for simplicity)

0

0.2

0.4

0.6

0.8

1.0

1.2

1.4

1.6

1.8

2.0

...

I then want the following in the sheet called 'summary'

0

0.5

1.0

1.5

2.0

How would I do this? Any help appreciated.