Answer export with list of associated products

Content

Hi all,

I'm currently having a problem creating a report that shows me ALL of the products associated to a particular knowledge article.

When I do an export and include the answer product field, it only gives me one of the products the answer is linked to. What I want to be able to do is export the knowledge article and in the same export see each individual product it is linked to, ideally delimited within one row. For example;

I'm seeing only the below:

Answer ID | Summary | Question | Answer | Product 1 | Category | Keywords etc.

I want to see:

Answer ID | Summary | Question | Answer |