How to insert rows in transposed data table?

[Mike]

Hello All,
I attempted to add rows in a pre-set transposed data table and was unable.
The message shows "you cannot change part of array". For those who have
answers, please kindly forward your advise to me, truly appreciate your help!
Regards,
Mike
[email protected]

[Hans Knudsen]

Am I right that you have used a matrix formula like: =TRANSPOSE(range)?
If so, try instead =INDEX($A$1:$D$10,COLUMN($A$1),ROW($A$1)) if you have your data in A1:D10.

Regards
Hans



"Mike" <[email protected]> skrev i en meddelelse news:[email protected]...
> Hello All,
> I attempted to add rows in a pre-set transposed data table and was unable.
> The message shows "you cannot change part of array". For those who have
> answers, please kindly forward your advise to me, truly appreciate your help!
> Regards,
> Mike
> [email protected]
>

[Hans Knudsen]

Sorry, the formula should have been:
=INDEX($A$1:$D$10,COLUMN(A1),ROW(A1))

Hans



"Hans Knudsen" <[email protected]> skrev i en meddelelse news:%[email protected]...
> Am I right that you have used a matrix formula like: =TRANSPOSE(range)?
> If so, try instead =INDEX($A$1:$D$10,COLUMN($A$1),ROW($A$1)) if you have your data in A1:D10.
>
> Regards
> Hans
>
>
>
> "Mike" <[email protected]> skrev i en meddelelse news:[email protected]...
>> Hello All,
>> I attempted to add rows in a pre-set transposed data table and was unable.
>> The message shows "you cannot change part of array". For those who have
>> answers, please kindly forward your advise to me, truly appreciate your help!
>> Regards,
>> Mike
>> [email protected]
>>
>
>