Easy to do
First, select the data, Row 1 in your case, that you want to transpose and copy it to the Clipboard using [Ctrl]+C.
Select the top-left cell of the range you want to copy the transposed data to (A1 for instance).
Click the Home tab (if necessary).
Click the Paste dropdown in the Clipboard group.
Click Transpose (the last icon on the second row).
That's it
Bookmarks