Open
Description
- For dynamic arrays you can simply do
=TRANSPOSE(...)
and you get it horizontally if it's a vertical array or vice versa. - 1d arrays in Python always translate to vertical ranges, which is OK. But it should be an easy thing to transpose it, very much like you can just wrap a transpose function around a dynamic array. Right now, the only way I found is to do something like this:
arr = pd.Series([1, 2, 3])
[arr]
Which I don't think is very intuitive? Maybe add something like the following?
excel.transpose(arr)