There are answers out there to this question, but all of them have been under explianed so hence to difficult to coprehend and use them to my advantage.

I want to do the seemingly simple (but not) task of Draging a Formula (Filling a series) across Column's while increasing the formula row number relativley.

For Example to drag this formula:

| =A1 | =A2 | =A3

Some other notes, Transposing by copy paste has proven too difficult for the amount of data.

Offset and Indirect has been used by other people to do this but I don't get how they work at all so when I attempt to use them I don't know how to format it to my range.

Here's a example photo

Idealy we want the dragged section to continue on to fill the formula.