Can the formula autofill be transposed?

[someone_somewhere]

If I have numbers down a column:
1
2
3
4
5

And then I type =A1, and move it DOWN the column… the formulas fill in reasonably. But I need to able to move it across rows.

However, I have some charts where the inputs and outputs are transposed from one another. If you look in the output, the I can’t get the formula autofill to be transposed.

Is there any way to transpose the formula autofill?

Failing that:

Whenever I try transpose formulas, it edits them. The only way I can get this to work is copy and paste the formula as text into the formula bar, after I edit hundreds of characters by hand in another editor.

Is there a way to at least automate that at all, so that I could maybe transpose the raw text of the formulas, and then have them act as formulas again? Or at least not have to copy and paste each and every line seperately?

[Lupp]

If you have a well defined and stable cell range you can transpose it as a whole entering the formula (like for your example) =A1:A10 with Ctrl+Shift+Enter for evaluation as an array formula.
This obviously comes with disadvantages concerning scaling (more/less source rows).
If you insist on fillable formulas with output to single cells, you should study the OFFSET() function.
The formula =OFFSET($A$1;COLUMN(C1)-COLUMN($C1);0) entered into C1 and filled to the right would do.
The transposition is done in this case using the column numbers of the target cells in the position telling the row numbers of the source cells needing to be referenced. All the source cells have no column offset as compared to the first one ($A$1). Therefore the 0 in the respective parameter position.
You have to accept different advantages this way.
More specific advice requires more specific information. Edit your question if you want to provide it.