If I have code for example 

```
SELECT DISTINCT 
    table1.column2, table2.column3, table2.column4 
FROM 
    table1
JOIN
    table2 ON table1.column = table2.column
WHERE 
    table1.column1 IN ('Value1', 'Value2')

```

This will return two rows of the same data, except each one will have one value that is different for a specific column. How can I bring the one value over and just have it result in one column?

for example it would currently result in something like this:

```
column1       column2        column3
Value1        Value2         Value3
Value1        Value2         Value5

```

Basically it creates two rows because in column 3, the values are different, is there any way I can bring that value 5 and make a separate column for it into the first row?

Would this involve pivoting or how could I go about in doing this?

Thank you for any help!