transpose array (excel)

with Transpose function

https://support.office.com/en-us/article/TRANSPOSE-function-ed039415-ed8a-4a81-93e9-4b6dfac76027

with copy /specialPaste

1. Select a cell range and choose Edit→Copy.
2. Select a destination cell.
3. Choose Edit→Paste Special.
4. Select the Transpose check box and then click OK.

https://support.office.com/en-us/article/Transpose-rotate-data-from-rows-to-columns-or-vice-versa-3419f2e3-beab-4318-aae5-d0f862209744