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.
Looks like you want the multi-row formula tool. I added some logic to make the total the number of cases in year 1 and to sort the end results so that Germany would come before Brazil similar to your output.