Skipping a column when dragging formula

Hi Everyone

Had a quick question, which I cant seem to find an answer for on the forum

I have information is Cells D2, F2, H2, J2, ... and so on, every second column as a number


I now want another line, which references those cells, so they can be in a single row, without column gaps, so i can make a graph, without having to manually select each cell

so basically the cells mentioned above (D2, F2, H2, J2), would now also be in a new row as (A3, B3, C3, D3)

from what I can figure, i need either the offset rule or the indirect rule, but I cant figure out how to make it work

Any help would be greatly appreciated


Kind Regards

Bharbir Heyer

Benishiryo

you are a genius, thankyou so much for your quick and excellent advice