What do you want to do with the data.
If you need it to go to someplace else using something like
=indirect("R"&row()-20&"C"&Column()*2-1)
in A24:E40 would group the data in your example.

"My View" wrote:

I want to select every second column between certain rows but I don't want
to do "A4:A20, C4:C20, E4:E20, G4:G20 ..... etc etc".

Is there a more efficient way to show this?

regards

PeterH