Auto Fill

[basssteakman]

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

[#2]

@basssteakman 

=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.