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.
Every day i receive this data that just has the month column, up until the first 12 (dec) I would like to have the year as the current year. Then after that the previous year. The data has multiple years in. So currently id like there to be a new column that says 2020, until it says 12 in the month column then 2019. Then when the month column is 12 for the first time again the year to say 2018 and so on. Ive attached a CSV of just the month column.
I think a multi-row formula and a formula tool can solve this. Please mind that towards the bottom of the csv file, there are some random "12" months followed by "8" rather than "11" (as an example have a look at record 1233). That will cause your year to jump from 2012 to 2011, so be mindful of that
Please let me know if that was what you've been looking for.