Forum Discussion
basssteakman
Apr 15, 2024Copper Contributor
Auto Fill
I need a way to automatically duplicate* the below tag set in a single column list while indexing the number in brackets [#] about 251 times (0-250). I'm using the latest version of the desktop app, not the web based one.
[CSV_TEST]test_recipe_array[2].SKU |
[CSV_TEST]test_recipe_array[2].CAR_Count |
[CSV_TEST]test_recipe_array[2].LAY_Count |
[CSV_TEST]test_recipe_array[2].PAL_Count |
[CSV_TEST]test_recipe_array[2].PAL_Pattern |
[CSV_TEST]test_recipe_array[2].BOX_Used |
[CSV_TEST]test_recipe_array[2].BOX_L |
[CSV_TEST]test_recipe_array[2].BOX_W |
[CSV_TEST]test_recipe_array[2].BOX_H |
[CSV_TEST]test_recipe_array[2].CARTON_UPC |
[CSV_TEST]test_recipe_array[2].EA_PART_UPC |
[CSV_TEST]test_recipe_array[2].PALLET_UPC |
- OliverScheurichGold Contributor
=SUBSTITUTE(TOCOL(IFNA(EXPAND(B1:B12,,251),B1:B12),,TRUE),"[2]","["&TOCOL(IFNA(EXPAND(SEQUENCE(251,,0),,12),SEQUENCE(251,,0)))&"]")
This formula works in my sheet if i correctly understand what you want to do. The result is in column K while columns G and I show intermediary steps.