Forum Discussion

basssteakman's avatar
basssteakman
Copper Contributor
Apr 15, 2024

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

     

Resources