Interrupted Transpose

Hi

Suppose that we have two columns including a million rows like this:
1.jpg

What is the right formula to make another arranged table? like this pic:
2.jpg

Any help would be appreciated


http://www.excelforum.com/excel-form...transpose.html
https://www.mrexcel.com/forum/excel-...transpose.html