EXCEL application form

Users questions: Ask a question every day, pass the form to me I want to form a table. Sexes and age, phone number call acceptance 133100XXXX1111 formats are the same Is there any way. Can do together so that they automatically Thank 7,777,771, if the format and phone number Location are the same code can be used "data * together" or be combined array approach. 2, if only the format column headers fixed, OK location of title is not fixed and the mobile number the number of new emergence can use VLOOKUP to find a No. 1 + VLOOKUP table look-up table with the No. 2 way be combined.
  • This information provided by the users.Thanks!