Converting span of years into list of distinctive years

[Rosohatica]

Hello all,

I am new to Alteryx and came across it while searching for an Excel solution. I think this is perfect software to solve my problem though,

So, I have an excel file which consists of river gauging station data. First column is a gauging station code, its just the name. Second column consists of spans of years during which the gauging has been working properly. Sometimes there are several spans in the cell separated by comma. And sometimes its a span and a single year. Anyway, the idea is to get a list of distinctive years instead of list of spans of years.There is around 1000 gauging stations I have to do this for. So doing it one by one is not an option, LOL.

Do you have an idea how?

I am attaching a screenshot  how the input table looks like and how I would like an output to look like.

Thanks.

  

[Rosohatica]

Hi mot,

thanks for the effort. I get these messages this time:

 

[mot]

Hi @Rosohatica ,

I just ran the workflow and I am not getting any errors. You may want to check if you're choosing the same excel sheet? Best.