Hi all,

I have got 3 columns with the column headings as follows

Column : A B C


Firstname Fathersname Mothersname

Jim Jack Mary
Raj
Rani
Susan John Diana

The desired output is given below

Column D E
Jim Jack
Jim Mary
Raj Rani
Susan John
Susan Diana

The logic should be in case if a person has father & mother then he
should have 2 rows in the output, if not he would have only one row in
the resulting set.

Do let me know how do i do this, i have got 500 such records to
update.

3 Cheers
Arun


--
daarun
------------------------------------------------------------------------
daarun's Profile: http://www.excelforum.com/member.php...o&userid=28954
View this thread: http://www.excelforum.com/showthread...hreadid=486827