CrazyEngineers Logo

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

Replies

  • Prasad Ajinkya
    Prasad Ajinkya
    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
    hey thanks i will try this

You are reading an archived discussion.

Related Posts

Complex FIR filter design example

Hi friends, I am going to design a COMPLEX FIR FILTER here. Any one who are interested can actively join me.

I VOTE NOBODY - Section 49-0

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!!...

What can you (I) do against terrorism?

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...

Do media reporters / journalists aid the terrorists?

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...

Mobile OS

can any one list out the available operating system for mobile phones?