INSERT INTO Customer_Information 
  (CustomerNumber, Name, Address1, Address2, City, 
   State, ZipCode, Email, DefaultPassword) 
VALUES (
   SELECT one, two, three, four, six, 
          seven, eight, nine , sixteen 
   FROM  info
   WHERE six is not null
   )