You have a column of cells with a year range, such as 2016-2020. How can you break those years out to new rows, so you have 2016, 2017, 2018, 2019, 2020. This Dueling Excel video uses VBA, Power Query, and the LET function to solve the problem.