Here is sample data in the format I currently have....
The output I need will be in the form of...
Household Name (Doe), Household Address, Household Phone, Adult1 (John), Adult2 (Jane), Child1 (Bambi), Child2 (upto Child6)
Does this make sense?
Thank you for your interest.
Gene