Create a Table or Matrix visual showing all fields from a one to many relationship in a single row

Hi CathyWork 

You should try to merge the two queries in the Query Editor (on the same column that you have the relationship set up currently), and then Pivot the CUSTFIELDNAME column, setting the CUSTFIELDVALUE as value. In the advanced options choose "do not aggregate".

Hope this helps! Let me know if you have any questions.

Hi CathyWork 

What do you mean by nested? Tables don’t actually nest fields. What looks “nested” usually comes from a matrix, which creates a hierarchical layout. If the goal is to display more fields in the row headers, the category needs to be expanded. It can be made to look like a table by switching the layout to Tabular and enabling Repeat row headers, but that still doesn’t change the underlying behavior.