Create New Rows Based on Values in a Single Row

bleu

Hi,

I'm trying to create new rows based on data in an existing row. The best way to explain it is using an example:

Data comes in a spreadsheet all sorts of ways, mixed and matched:

Apple Batch 10-13          0.75

Apple Batch 15-18          0.15

Banana Batch 10-13       0.25

Pear Batch 20-23            0.00

Red Grape Batch 30-33  0.15

I'd like to get:

Apple Batch 10         0.75

Apple Batch 11         0.75

Apple Batch 12         0.75

Apple Batch 13         0.75

Apple Batch 15         0.15

Apple Batch 16         0.15

Apple Batch 17         0.15

Apple Batch 18         0.15

And so on and so forth

To make matters worse I have 9 types of fruit and 14 groups:

10-13

15 - 18

20 - 23
25 - 28
30 - 33
35 - 38
40 - 43
45 - 48
50 - 53
55 - 58
60 - 63
65 - 68
70 - 73
75 - 78

Any ideas or a link to where something like this was already posted would be appreciated!

Emil_Kos

Hi @bleu,

First what I needed to do is creating the data in a correct format. 

Regex was really good for that. 

Afterwards, the row generator did the work. 

The workflow:

The output:

New Category.yxmd