1. Copy the cells from sheet 1.
2. Select the top cell of the first column in sheet 2
3. Open Find & Replace (Ctrl + F)
4. Open the options in Find & Replace and change "search by rows" to "search by columns"
5. Leave the value you're searching for blank.
6. Click "Find Next"
7. Paste special (values only)
Only works if you have no other blank cells above the cell you want to paste into.