split years from one cell to multiple cell

jasonsnare

HI,

I have one dataset and it contains the year ranges in one cell (1993-1996). I want to split each year into separate cells (1993,1994,1995,1996). Does anyone have an Idea suggest me.

Rushil09

Hi,

How exactly will the cells be laid out? in form of columns?

Can you sen the screenshot of what you want to do if i am getting this wrong.

AlexGo

If you want to use the visual recipe steps and you have a consistent format, you could do something like:

1. Split the cell on '-',
2. Use a formula such as "forRange(year_range_0,year_range_1, 1+1, v, v)"
3. Unnest the array into separate columns

This gets the first and last year, takes all years between the first and the last, steps through each year and then applies a formula to it (in this case the formula is just returning the value).

You might have issues if the format is inconsistent though e.g. there's a single year. You would have to edit the formula step to include an 'if' to check for things like this.