Select A1 to A5. Click the Home tab. Then click the Copy button. Click B1. Then click the Paste button arrow. Then click Transpose. Check the result.