I have been looking for a way to do this but I can't seem to find the solution.

How can I select and group by without removing all possible variables from column 2 where variable is non existent for variable from column1?

![Excel Example](https://i.stack.imgur.com/wowPl.png)

Data Example (left) - How I would like it to be (middle) - current (right)

When I would do this:

```

SELECT Column1, Column2, COUNT(*) 
FROM Table
GROUP BY Column1, Column2;

```

If I would use this line of code, I won't be able to see all the variables from column2 for each variable for column1 (which I would like to). Because if they don't exist it won't show in the results.

So I would like to see all the variables from Column1 with all 4 possible variables from Column2 and then the count for the amount this combination exists.

Thanks for the help in advance, hope my question is clear.