Transpose formula does not work as it should

Hello all!

I’m having a problem to insert a formula into excel! The result is the image you see below. It does work for that particular cell but it does not Transpose the table as I wish.
The formula also has “@” which I did not add. In UiPath my cell content is set to “=TRANSPOSE(PL!A1:O42)”.
Instead of using write cell activity I also tried the write range activity and I got the same result.
Tried both Excel Write Cell Activity and Workbook Write Cell Activity.

image

Thank you in advance.