copy formula vertical and paste horizontal

[Guest]

dear all, is there any method that i can copy formula and paste different
direction?
let say to derive value in c2, c3, i just drag down to copy the formula as
below

a b c
1 5 3 =a1+b1
2 4 2
3 6 8

any method or formula for example wages value which store vertically can
paste horizontally in P&L(i put = at the cell just like example above)
instead of copy manually cell by cell?

Cash book
revenue {wages} purchase travelling
jan -1000 {100} 200 300
Feb -500 {250} 350 450
mar -700 {550} 400 750

P/L
Jan Feb Mar
Sales -1000 -500 -700
{wages 100 250 550}
purchase 200 350 400
travelling 300 450 750

 

[Max]

Perhaps one way is via using TRANSPOSE() ..

Assuming the table below
is in Sheet1, in A1:E4
(a 4R x 5C grid)

revenue {wages} purchase travelling
jan -1000 {100} 200 300
Feb -500 {250} 350 450
mar -700 {550} 400 750

In another Sheet2
------------------------
Select A15
(range selected must be a 5R x 4C "converse" grid)

Put in the formula bar: =TRANSPOSE(Sheet1!A1:E4)
Array-enter the formula,
i.e. press CTRL+SHIFT+ENTER
instead of just pressing ENTER

If desired, suppress extraneous zeros from display via:
Tools > Options > View tab > Uncheck "Zero values" > OK

A15 should return the desired transposed table:

Jan Feb Mar
Sales -1000 -500 -700
{wages 100 250 550}
purchase 200 350 400
travelling 300 450 750

 

[Max]

Another alternative to play with ...
(maybe simpler to set-up)

With the same table in Sheet1

In Sheet2
-------------
Let's reserve row1 for your header: P&L

Put in the starting cell, A2:
=OFFSET(Sheet1!$A$1,COLUMN(A1)-1,ROW(A1)-1)

Copy A2 across to D2, fill down to D6

This'll also return the desired "transposed" table
which is dynamically linked to the table in Sheet1