To interleave two columns in Microsoft Excel, follow these steps:
[list=1][*]Open your Excel worksheet and select a blank cell where you want to start the interleaved data.[*]In the formula bar, type the following formula:
Code:
=IFERROR(INDEX(A:A,ROW()/2),INDEX(B:B,(ROW()+1)/2))
[*]Press Enter to apply the formula to the selected cell.[*]Copy the formula down to the rest of the cells in the column.[*]The resulting column will now consist of the interleaved data from the two columns.
Note: In the formula,
"A:A" and
"B:B" refer to the two columns of data you want to interleave. If your data is in different columns, you will need to adjust the formula accordingly. Also, if your data starts in a different row, you will need to adjust the formula to start at the correct row.