transpose

[mango]

dear all, if i use hide in cash flow to make this in converse to p&l
so that cash flow is 3R5C and p&l 5R3C
cannot work as hidden rows also count in.
i don't want to copy and paste special then only transpose.
any other way?
pls help.

cash flow
exp 1 exp 2 exp 3 exp 4 exp 5
jan
100 200 300 400 500
5 6 7 8 9
105 206 307 408 509 (row1)

feb
150 250 350 450 550
10 9 8 7 6
160 259 358 457 556 (row2)

mar
200 300 400 500 600
20 19 18 17 16
220 319 418 517 616 (row3)


P&L
jan feb mar
exp 1 105 160 220
exp 2 206 259 319
exp 3 307 358 418
exp 4 408 457 517
exp 5 509 556 616

 

[Frank Kabel]

Hi
if I understood you correctly this is only possible using VBA

 

[Paul Lautman]

The TRANSPOSE array function?

 

[Max]

The TRANSPOSE array function?

The above was one of 2 suggestions offered
to the OP's 1st post 2 days earlier,
ref: http://tinyurl.com/55s6x

For some reason, OP seems reluctant to respond
to replies given within the same thread (despite advise given),
and prefers to continue discussions by posting as a new post daily
(at the rate of one new post a day for the past 2-3 days !)

OP's latest post is actually a pick-up of Mike Middleton's response
to his/her 2nd post, re: http://tinyurl.com/65ygg
(in which Frank K also replied in the same manner
as he did to this post <g>)