HOWTO: Move every other row to column with any spreadsheet (Google Sheets or MS Excel)

Basic 

1. Copy all data from second row to last

2. Paste data to second column starting on the first row

3. In third column or new column, alternate 0 and 1

4. Sort by new column

5. Delete all rows not needed

Alternative

3a. Use row count

4a. Use if even/odd to filter the rows

More Rows

1. Use formula to extract data from next row to column

1a. Second column equals second row

1b. Third column equals third row

1c. Repeat until last data in set

2. Copy all the new columns

3. Paste as value in new columns

4. Delete formulated columns

5. Use new row to count (use either method from Basic or Alternative except expand to needed column count)

6. Sort or filter (use either method from Basic or Alternative to delete unneeded rows)