Skip to content

Instantly share code, notes, and snippets.

@dbjpanda

dbjpanda/Spreadshhet

Created March 28, 2020 17:36
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 dbjpanda/dda69e866cd39f6e98699afa846d8210 to your computer and use it in GitHub Desktop.
Save dbjpanda/dda69e866cd39f6e98699afa846d8210 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Spreadshhet
=ArrayFormula
(
ArrayFormula(VLOOKUP(CEILING(ROW(OFFSET(INDIRECT("A1"),,,COUNTA(A2:A)*COUNTA(B2:B)))/COUNTA(B2:B)) , {ROW(A2:A)-row(A1),A2:A} , 2, ))
&
ArrayFormula(VLOOKUP(MOD(ROW(OFFSET(INDIRECT("A1"),,,COUNTA(A2:A)*COUNTA(B2:B)))-1,COUNTA(B2:B))+1 , {ROW(B2:B)-ROW(B1) , B2:B} , 2 ,))
&
C$2
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment