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'm struggling with transforming data. I have attached the excel spreadsheet that shows what my input file looks like and also my desired output. For me, it is tricky to move each jurisdiction down with the values included and stack them on top of each other. The format of my output file has to be in the same way that I want in the spreadsheet.
Much appreciated if anyone has a solution for this. Thanks!