see the following post - i think it should work regardless of the data:
http://www.mrexcel.com/forum/excel-questions/742255-one-column-into-two-using-alternate-rows.html
http://www.mrexcel.com/forum/excel-questions/742255-one-column-into-two-using-alternate-rows.html
Let's assume your data is in column A. In column B, you want to make it like this:
1
2
1
2
and then copy that pattern down to the end of your data set using autofill.
Then turn on a filter on column B, filter it to 1. Cut those records out and paste them into a separate workbook. Then filter to 1 and paste that row in the new workbook next to the first one. Make sense?
1
2
1
2
and then copy that pattern down to the end of your data set using autofill.
Then turn on a filter on column B, filter it to 1. Cut those records out and paste them into a separate workbook. Then filter to 1 and paste that row in the new workbook next to the first one. Make sense?
