Can any one help me to get the Flat file for my requirements.

Input Format
-------------------

MemberID MemberName DependentID DependentName  DependentDOB

12345 Mohan           55555            Chandru         01/01/2000
12345 Mohan           44444            Bandruu         01/01/2005
12345 Mohan           33333            Vendruu         01/01/2003
67890 Srinath         11111            Viji            01/01/2002
67890 Srinath         22222            Kalai           01/01/2002


Now I  want to generate the flat file with the following format. (i.e)


MemberID MemberName followed by the Dependent Information.

The output would be two rows in a Flat File  for the above input.

Thanks in advance.
Sathish

[ Post a follow-up to this message ]