Splitting the tables in MS EXCEL

babloo0311

babloo0311

@babloo0311-J22PBc • Oct 22, 2024
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
Like 0 Replies 2

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

Sign up Log in

CrazyEngineers powered by Jatra Community Platform

  • Prasad Ajinkya

    Prasad Ajinkya

    @prasad-aSUfhP • 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.
    0
  • babloo0311

    babloo0311

    @babloo0311-J22PBc • Nov 28, 2008

    hey thanks i will try this
    0