Is there a way to spread out a value in a row into different rows?

Occasional Visitor

Lets say i've this data:


See how the row, in years, goes from 2008-2018, in one row.


What I need, is this. Select a row and spread the years like I do here.


It was manually changed from 2008-2016 to this, every row has a year. The remaining data was copy/pasted.


Is there a way to automate this? The thing is I've like 600 rows with values like this.

0 Replies