Forum Discussion
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, ...
=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.
