CrazyEngineers
CrazyEngineers
  • Hello friends,

    In Excel i have master table like name, age, phone_no, mail_id
    i must split this into two detail table like one having name n age and othet having phone_no n mail_id

    Is it possible in Excel

    i know its possible in ms access , sql but without using all these is it possible
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies

  • Prasad Ajinkya

    Member • Nov 27, 2008

    Re: Excel

    Babloo,

    Just separate the two columns 😀 ... if you do have a common column that you wish to retain in both the tables, then use the vlookup() function in excel.
    Are you sure? This action cannot be undone.
    Cancel

  • babloo0311

    Member • Nov 28, 2008

    hey thanks i will try this
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register