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
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
-
Prasad AjinkyaRe: 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. -
babloo0311hey 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?