I'm working with a MS Access 2016 Database that was used by a client using a software based e-commerce application that was very old and dated.

I've created an SQL statement to abstract the data I need for creation of a CSV for Shopify



The SQL gets what I want, but creates many duplications of content due to the way the data is held in the Database,

There's a table in the Database called Variable that holds variable definitions created by the end user when using the e-commerce software. Such as:- if a Product was to have multiple images associated with it they could create ExtraImage1, ExtraImage2 which then be available for all products

There's a second table called UserDefinedVariables that holds the values of the Variables that are associated to products.

My issue is the above SQL gives the output of:



The repetition of content for sString1 to 4 is expected as these are product dropdown content. However, in my Database I want to output the values of variables ExtraImage1 to 4 without it grouping them as it does. Is there a way I could state in SQL when there's an occurrence of ExtraImage1 found in sName create a column header called ExtraImage1 and place its associated value from UserDefinedProperties.sValue directly under it in the new column?