The school has a scenario where the bus route chosen for each student is tracked on a custom field. The school would like to get a list with one row per family, where the following is listed: parent name and contact info (email, wireless), the each of their enrolled child names/grade/custom field value. They do not want separate rows per student or per household. We frequently pull similar lists where one row per family (not per household or per student) is requested. They typically do not want non-enrolled siblings included. Advanced Lists are difficult as they work now in the simple fact that we have to add tons of Object Filters to avoid inclusion of grandparents and often relationship 2 is blank while relationship 3 or 4 is populated (blank columns of parent information before populated columns). Tt is all very messy to share lists of information with users that are not savvy in making edits/working in spreadsheets.

I understand why it doesn't work this way; this is just the consequence of the database structure, and to do this you have to be able to determine (or have the user provide) which fields are one-to-many (like child-parent) and which are one-to-one. I wrote a spreadsheet add-on for Google Sheets to flatten any multi-line list. That could be a good interim way to do it.