Skip to content

Instantly share code, notes, and snippets.

@nsdevaraj

nsdevaraj/repeat text

Created March 5, 2024 02:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nsdevaraj/95749963b6127f1924893a375011d025 to your computer and use it in GitHub Desktop.
Save nsdevaraj/95749963b6127f1924893a375011d025 to your computer and use it in GitHub Desktop.
Download ZIP
excel repeat text
Raw
repeat text
=TOCOL(TEXTSPLIT(TEXTJOIN("",TRUE,REPT(ROW(C1:C133)&",",C1:C133)),",",,TRUE)*1,3)
=DROP(REDUCE("",E1:E1330,LAMBDA(a,v,VSTACK(a,IFNA(VLOOKUP(v,HSTACK(ROW(A1:A133),A1:B133),{2,3},FALSE),{"",""})))),1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment