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 two years of data in one file and need to create difference columns. Below is a simple display of the data I have. I am looking for a way to dynamically create columns such as 'Expense Difference' that will be able to calculate the difference of the two columns based on the name of the field, in this case having 'Expense' in their name. My actual dataset has 30-40 fields for each year and the fields have the same name year over year other than starting with 2018 or 2019.