So what xlstime is saying is that you can use something like this in your
row 5 cells
D5=Offset(E7,Column()-Column($D$5),0) and copied across
or
D5:AX5=Transpose(E7:E250)... this has to be entered as an array formula
Regards,
Sam Mathai Chacko
On Sat, Mar 30, 2013 at 10:40 PM, xlstime wrote:
Hi Priti,
we have lots of way (i.e..) offset (formula),transpose (formula) with array
and paste special transpose (function)
.
Enjoy
Team XLS
On Sat, Mar 30, 2013 at 9:11 PM, Priti_verma wrote:
> Hi ,
>
> I am new on this group I have query plz help me?
>
> Hi
Hi ,
I am new on this group I have query plz help me?
Hi!
I have a repayment schedule, the monthly instalments are in a row (eq from
E7 -> E250) and I must to transpose these values in a row, in other sheet
(from D5 -> AX5);
I don't want to use Copy - paste special...I have tried with to use "$