I am trying to combine data collected in CRM from regular fields, and subform fields, and have them listed in rows.

Creating a report from scratch, and adding the subform as a related list, I get the following results:

As you can appreciate from the screenshots, subform data Is entered correctly, and for every entry, a new row is created. But the information coming from regular fields gets duplicated from every subform entry. 

I am looking to create a report like this:


I could simply skip the standard fields altogether, and only use subforms, but given the limitation of 10 subform fields, this is not a viable option to collect data from our customers. 

Having spoken with support, they mentioned there is no way around this, that it is the intended behavior and limitations CRM currently has. 

The only workaround I have thought of is creating 2 separate csv reports with the exact same columns and then merging both files into one. Its a few more steps, but I am just boggled that CRM cannot handle this simple request, am I missing anything? or can anyone think of a workaround? Any help would be greatly appreciated