This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I would like to get every combination of the following data:
so it looks like this:
I tried using cross tab to get the countries along the top but then it leaves it as this:
I feel like I am on the right track, but I need those blanks to be populated and then for them to all be in one column, like the 2nd table example. It also needs to be a scalable and flexible solution as in my actual data set, the numbers in both fields will vary