Dynamically creating new rows from a cell with a range of values

[wvanbus93]

I am trying to dynamically create new rows from a column that has a range of values (e.g. 0100 - 0199).

I am looking to create a row for each value (0100, 0101, 0102, etc.)

Category CodeCategory NameSIC Code

1	Agric  Agriculture	0100-0199
1	Agric  Agriculture	0200-0299
1	Agric  Agriculture	0700-0799
1	Agric  Agriculture	0910-0919
1	Agric  Agriculture	2048-2048
2	Food   Food Products	2000-2009
2	Food   Food Products	2010-2019
2	Food   Food Products	2020-2029
2	Food   Food Products	2030-2039
2	Food   Food Products	2040-2046

I have attached the entire file for reference as well.

Thanks,

[OllieClarke · Accepted solution]

Hi @wvanbus93 You can use the generate rows tool to do this:

[Jonathan-Sherman · Accepted solution]

Hi @wvanbus93,

I think this is what you're trying to achieve, i've used the generate rows tool.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan