Organize data into columns

"alternating data similar to"

Your description of the data needs to be EXACT or I'm wasting my time.

How many columns wide is this data? It appears to be 8. Is that correct or is it some other figure?

With data starting in Sheet1!A1 and
assuming this data is 8 columns wide

in Sheet2!A1
=INDEX(Sheet1!$A$1:$H$3,MOD(COLUMN(),2)+INT((ROW()-1)/4),MOD((ROW()-1)*2+1,8))

in Sheet2!B1
=INDEX(Sheet1!$A$1:$H$3,MOD(COLUMN()-1,2)+INT((ROW()-1)/4),MOD((ROW()-1)*2+1,8)+1)

and copy down the rows