Charge singlets and orbital-selective charge density wave transitions