My data source in an excel spreadsheet. Each row is a Branch. Each column is a year (2010 - 2016).
I have loaded the data into a table and I want the user to be able to pick a year and limit the data that is visible. I am not sure if or how I can do this with excel.
2010 2011 2012 2013 2014 etc.
Branch A 100 200 300 500 700