Generate Rows

[Jo-B]

Dear all, 

I would like to generate rows based on a figure in a table. 

On-time	all
4	5
2	4

The end product should look like that:

on-time	all
1	1
1	1
1	1
1	1
0	1
1	1
1	1
0	1
0	1

Do you have any idea for me?

Many thanks in advance!

[jdunkerley79 · Accepted solution]

I suggest the attached.

Generate rows for the all columm

Then use a formula tool to adjust the on-time to be 1/0 

Finally another formula to change all to 1

[michael_d · Accepted solution]

Hi Jo-B,

Try this workflow, hope it helps.

Thanks,

Michael

[Jo-B]

Dear Both!

Thanks for the quick help! Really appreciated the great support! :-)