The easiest option would be to split them into two separate Excel files and then select columns 1-4 as above.