Input the formula: =TRANSPOSE($A$2:$C$2). And Select A7, A8, A9. Press Shift+Control+Enter to get the result.