I have a sheet that I need to autofill down from a cell value. So item A to repeat its name 40 times starting on sequence 1 than immediately after Item B 10 times and so forth. The order of Item A-D will change as well since sometimes I may want Item B first than Item A etc.
Thanks for anyone who can assist.
<tbody>
</tbody>
Thanks for anyone who can assist.
Item A | 40 | |||
Item B | 10 | |||
Item C | 5 | |||
Item D | 7 | |||
Sequence | Item Name | |||
1 | ||||
2 | ||||
3 | ||||
4 | ||||
5 |
<tbody>
</tbody>
Last edited: