This is exactly the type of work that
http://www.gmayor.com/ManyToOne.htm was developed for. If you like this, look out for a major update to the e-mail capability (currently under test by selected users), hopefully later this week.
Because rows are added as required you will need to insert a very narrow row after the title row to avoid replicating the title row border:
when merged gives for id #1
