Re-organising data into new records in Dynamic View

Re-organising data into new records in Dynamic View

Imagine a family database with this sort of data.

Record 1
  Parent A's name
  Parent A's Date of Birth
  Parent B's name
  Parent B's Date of Birth
  Child A's name
  Child A's Date of Birth
  Child B's name (etc.)

These records also have addresses and telephone numbers etc.

This is great for the first part of my needs - I export to an XLS and then merge it into a Family Address Book Word doc, which I export as a PDF.

However, I would also like to create a Birthday list, sorted by date. I guess I need a view which pulls in the names and DOBs from the above app and sort of creates a new app with individual records for each person.

Can this be done?

Thanks, Glenn.