babloo0311
babloo0311
Branch Unspecified
27 Nov 2008

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

Branch Unspecified
28 Nov 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.
babloo0311

babloo0311

Branch Unspecified
28 Nov 2008
hey thanks i will try this

Share this content on your social channels -

Only logged in users can reply.