Splitting the tables in MS EXCEL

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


  • Prasad Ajinkya
    Prasad Ajinkya
    Re: Excel


    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.
  • babloo0311
    hey thanks i will try this

You are reading an archived discussion.

Related Posts

Hi friends, I am going to design a COMPLEX FIR FILTER here. Any one who are interested can actively join me.
There is a Rule that gives you the Right to refuse voting. Section 49-0 seems to give you that right..... This could mean Re-election and dsqualification of all the candidates!!...
The question has been hovering over our minds since long time. Every time there is some terrorist activity, all we do is watch the 'breaking news' on television. Then we...
Disclaimer: This discussion/debate is not meant to be 'against' journalists or TV reporters or media people. I respect your profession very much. I do not mean to hurt anyone's sentiments...
can any one list out the available operating system for mobile phones?