1. Home >
  2. Apps >
  3. Groups >

Splitting the tables in MS EXCEL

Question asked by babloo0311 in #Coffee Room on Nov 27, 2008
babloo0311
babloo0311 · Nov 27, 2008
Rank C3 - EXPERT
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 Posted in: #Coffee Room
Prasad Ajinkya
Prasad Ajinkya · Nov 28, 2008
Rank B1 - LEADER
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.
babloo0311
babloo0311 · Nov 28, 2008
Rank C3 - EXPERT
hey thanks i will try this

You must log-in or sign-up to reply to this post.

Click to Log-In or Sign-Up