| Excel | Ever need to merge two excel columns together? And by merge I don't mean concatenate or actaully merge the cells. In this case, the need was to take two columns and shuffle them together like a deck of cards. Here's the command: =IF(MOD(ROW(),2)=1,OFFSET($A$1,INT(ROW()/2 + 0.5)-1,0,1,1),OFFSET($B$1,INT(ROW()/2 + 0.5)-1,0,1,1)) |