Excel Help Transferring Raw Data

Anyone who can help,

I am trying to move data from a 4 column worksheet (Worksheet A) to a 2 column worksheet (Worksheet B). In worksheet B, the cell in the first column, first row will contain column 1, row 1 from worksheet A, and the cell below it will contain columns 3 an 4, row 1 from worksheet A. However, when I match one worksheet to the other (= sign other worksheet), and try and scroll down, it skips rows).

Little confusing but if anyone has an idea of what function or equation to use, I'd appreciate it.

Thank you.