Hi All,
I have a scenario where I am trying to increase my efficiency at work because my current process usually takes ages!
I have a list that needs to be copy/pasted multiple times but in different amounts. Can this be coded somehow? I usually insert rows in between each different row and guestimate how many blank spaces there need to be minus 1. Then I perform the drag down copy method to ensure that the rows are identical.
Is there an easier way to do this!?
Fruity example: [TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Contents 1[/TD]
[TD]Contents 2[/TD]
[TD]Contents 3[/TD]
[TD]Contents 4[/TD]
[TD]No. of times to be copied[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]Orange[/TD]
[TD]Pear[/TD]
[TD]Banana[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Carrot[/TD]
[TD]Broccoli[/TD]
[TD]Turnip[/TD]
[TD]Cabbage[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Water[/TD]
[TD]Juice[/TD]
[TD]Milk[/TD]
[TD]Coke[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Final output wanted:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Contents 1[/TD]
[TD]Contents 2[/TD]
[TD]Contents 3[/TD]
[TD]Contents 4[/TD]
[TD]Number[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]Orange[/TD]
[TD]Pear[/TD]
[TD]Banana[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]Orange[/TD]
[TD]Pear[/TD]
[TD]Banana[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Carrot [/TD]
[TD]Broccoli[/TD]
[TD]Turnip[/TD]
[TD]Cabbage[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Carrot[/TD]
[TD]Broccoli[/TD]
[TD]Turnip[/TD]
[TD]Cabbage[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Carrot[/TD]
[TD]Broccoli[/TD]
[TD]Turnip[/TD]
[TD]Cabbage[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Water[/TD]
[TD]Juice[/TD]
[TD]Milk[/TD]
[TD]Coke[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Water[/TD]
[TD]Juice[/TD]
[TD]Milk[/TD]
[TD]Coke[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Water[/TD]
[TD]Juice[/TD]
[TD]Milk[/TD]
[TD]Coke[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Water[/TD]
[TD]Juice[/TD]
[TD]Milk[/TD]
[TD]Coke[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]
I have a scenario where I am trying to increase my efficiency at work because my current process usually takes ages!
I have a list that needs to be copy/pasted multiple times but in different amounts. Can this be coded somehow? I usually insert rows in between each different row and guestimate how many blank spaces there need to be minus 1. Then I perform the drag down copy method to ensure that the rows are identical.
Is there an easier way to do this!?
Fruity example: [TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Contents 1[/TD]
[TD]Contents 2[/TD]
[TD]Contents 3[/TD]
[TD]Contents 4[/TD]
[TD]No. of times to be copied[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]Orange[/TD]
[TD]Pear[/TD]
[TD]Banana[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Carrot[/TD]
[TD]Broccoli[/TD]
[TD]Turnip[/TD]
[TD]Cabbage[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Water[/TD]
[TD]Juice[/TD]
[TD]Milk[/TD]
[TD]Coke[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Final output wanted:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Contents 1[/TD]
[TD]Contents 2[/TD]
[TD]Contents 3[/TD]
[TD]Contents 4[/TD]
[TD]Number[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]Orange[/TD]
[TD]Pear[/TD]
[TD]Banana[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]Orange[/TD]
[TD]Pear[/TD]
[TD]Banana[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Carrot [/TD]
[TD]Broccoli[/TD]
[TD]Turnip[/TD]
[TD]Cabbage[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Carrot[/TD]
[TD]Broccoli[/TD]
[TD]Turnip[/TD]
[TD]Cabbage[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Carrot[/TD]
[TD]Broccoli[/TD]
[TD]Turnip[/TD]
[TD]Cabbage[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Water[/TD]
[TD]Juice[/TD]
[TD]Milk[/TD]
[TD]Coke[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Water[/TD]
[TD]Juice[/TD]
[TD]Milk[/TD]
[TD]Coke[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Water[/TD]
[TD]Juice[/TD]
[TD]Milk[/TD]
[TD]Coke[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Water[/TD]
[TD]Juice[/TD]
[TD]Milk[/TD]
[TD]Coke[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]
