- Registration date
- Sunday September 12, 2010
- Last seen
- June 8, 2021
That looks like you want to use the transpose option in the Paste Special menu.
Copy A1:B1, then right-click A2 and select paste special. Mark the transpose option and the data will now also be in A2:A3.