Splitting data into rows

[SCK]

Hi all. I need help in splitting the data into multiple rows. I have this weird data set that I cannot manage to split. The input looks like below:

Input:

Data

Range

revenue

420170 + 420000 + 420010 - 420010-0003345 - 420010-0003533 - 420010-0003406 - 420010-0003407 - 420170-000AETN - 420170-00AETNA - 420010-0003408 - 420010-0003304 - 420170-0003975 - 420170-0003954 - 420010-0003978 + 420011 - ZACCINS

revenue2

420060:420090

I need the output to like something like below:

Data	Range
revenue	420170
revenue	420000
revenue	420010
revenue	420010
revenue	0003345

Basically, there is no consistency in terms in delimiter, so i am unable to split the data. Would be huge help if you could give me a solution

[Qiu]

@SCK 
Hope this is something you need.

[messi007]

@SCK,

Another way how to do this 🙂

Hope that helps!

Regards,