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

Copper Contributor

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.

 

https://imgur.com/a/gtamdj8

 

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