View Feed
Coffee Room
Discuss anything here - everything that you wish to discuss with fellow engineers.
12933 Members
Join this group to post and comment.
babloo0311 • Nov 27, 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 • Nov 28, 2008
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 • Nov 28, 2008
hey thanks i will try this

Share this content on your social channels -