[Solved] Moving info in a row to a column with formula

[cartoonjazz]

Is it possible to have calc fill formulas based on an incrementing cell letter rather than number?

the source data from another tab in a worksheet is listed horizontally in a row not vertically in a column. So instead of autofill incrementing A1, A2, A3,,,etc. We require it to fill A1, B1, C1 etc.
source sheet 1 looks like this


sheet 2 should show the data in sheet i vertically instead of horizontally

[RusselB]

Do the auto-fill in the same direction as the data.
While a formula could be written to properly account for the increasing column designator while going down rows, it's easier to work with what's already coded to the program

[cartoonjazz]

Thank you, that does work however I really need to to do it the way described. I wonder if there is a formula for generating it the way I require. ie make the letter part of the formula an expression that increments by 1 and leaving the number part of the cell. You mentioned there was a way of doing this can you point me in the right direction of how you would build the formula?

[MrProgrammer]

Is it possible to have calc fill formulas based on an incrementing cell letter rather than number?

[Solved] Moving info in a row to a column

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[cartoonjazz]

Thank you I looked at that offset formula and tried implementing it with no success. wondering if anyone can help me with a suggestion re the syntax of any formula that will get this to work.

[Zizi64]

Try the array function named: TRANSPOSE()

[cartoonjazz]

transpose works great thank you