Merge Queries Without Repeating the Values

Hi Everyone. Askig for help regarding my data model and merging columns   I have two tables with one-to many relationship. I want to avoid repeating the values of 'Value' in Table 1 when merging to...