[Solved] Filling down, from another sheet's across cells

[Dongatrash]

I have 2 sheets, one has totals in a row, I want those totals to fill another sheet's column.
Can this be done?
IE I have Income listed in rows, with totals for each field at the bottom of each column.
On a separate sheet (same file), I want to do a profit/loss, with fields in a column, and totals for them in a column, filled from the income sheet.

[karolus]

Hallo

enter something like:

Code: Select all

=TRANSPOSE(other_sheet.A30:Z30)

into the top_cell of the Target_Range

[Dongatrash]

Doesn't work, sorry. But now I can explain better.
I have 8 rows and one column in sheet 2 I want to transpose 1 row and 8 columns from sheet 1 into sheet 2.
Can this be done?

[robleyd]

Is this what you want? Sheet1 is the source, Sheet2 is the transposed values.

transpose.ods

(8.04 KiB) Downloaded 119 times

Or this where Sheet2 is the source and Sheet1 is the transposed values.

transpose2.ods

(8.06 KiB) Downloaded 110 times

[Dongatrash]

YES, THE 2ND ONE.
SO HOW DID YOU DO IT PLEASE? I CANNOT REPLICATE...

[robleyd]

Please don't SHOUT, it is considered impolite.

Press F1 to open Help; search Transpose and see the process described.

[Dongatrash]

Sorry, capslock was on. I got it! Thank you, I misread the shift control enter part in help.
Thankyou, thankyou, thankyou!