Answer is:
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.
Answer is:
Fill the selection with active cells to the right
Answer is: