I need to be able to combine a spread sheet with data on for 2 different years spend (i.e 2016/17 & 2017/18), I want to keep the years data separate but compare each customers spend trends.
So really I am looking to merge the list of customers and for the spend to follow these movements but to ensure that each years spend stays separate. I hope this makes some sense.
Solved by B. U. in 11 mins