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 have a data set containing information about year 2021 and year 2022. The column year 2021 is fixed and is not going to change. However column "Actual "changes with new name every week. I want to create a new column that shows me only the changes. Ex: if I have Silver in column 2021 and it stays silver I don't need it to be shown, but however if silver becomes gold I need it in the data base. Attached also is an example of the data. Thanks a lot !!!