0

For every day of the year, I need the day repeated in 10 rows. How can I accomplish this efficiently?

e.g.
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/02/2019
01/02/2019
01/02/2019
01/02/2019
01/02/2019
01/02/2019
01/02/2019
01/02/2019
01/02/2019
01/02/2019
... (all other dates)
12/31/2019
12/31/2019
12/31/2019
12/31/2019
12/31/2019
12/31/2019
12/31/2019
12/31/2019
12/31/2019
12/31/2019

migrated from superuser.com Jan 10 at 21:28

This question came from our site for computer enthusiasts and power users.

0

=ARRAYFORMULA(TO_DATE(TRANSPOSE(SPLIT(REPT(DATE(2019,1,1)&"|",10)&REPT(DATE(2019,1,1)+1&"|",10)&
 REPT(DATE(2019,1,1)+2&"|",10)&REPT(DATE(2019,1,1)+3&"|",10)&REPT(DATE(2019,1,1)+4&"|",10)&
 REPT(DATE(2019,1,1)+5&"|",10)&REPT(DATE(2019,1,1)+6&"|",10)&REPT(DATE(2019,1,1)+7&"|",10)&
 REPT(DATE(2019,1,1)+8&"|",10)&REPT(DATE(2019,1,1)+9&"|",10)&REPT(DATE(2019,1,1)+10&"|",10)&
 REPT(DATE(2019,1,1)+11&"|",10)&REPT(DATE(2019,1,1)+12&"|",10)&REPT(DATE(2019,1,1)+13&"|",10)&
 REPT(DATE(2019,1,1)+14&"|",10)&REPT(DATE(2019,1,1)+15&"|",10)&REPT(DATE(2019,1,1)+16&"|",10)&
 REPT(DATE(2019,1,1)+17&"|",10)&REPT(DATE(2019,1,1)+18&"|",10)&REPT(DATE(2019,1,1)+19&"|",10)&
 REPT(DATE(2019,1,1)+20&"|",10)&REPT(DATE(2019,1,1)+21&"|",10)&REPT(DATE(2019,1,1)+22&"|",10)&
 REPT(DATE(2019,1,1)+23&"|",10)&REPT(DATE(2019,1,1)+24&"|",10)&REPT(DATE(2019,1,1)+25&"|",10)&
 REPT(DATE(2019,1,1)+26&"|",10)&REPT(DATE(2019,1,1)+27&"|",10)&REPT(DATE(2019,1,1)+28&"|",10)&
 REPT(DATE(2019,1,1)+29&"|",10)&REPT(DATE(2019,1,1)+30&"|",10)&REPT(DATE(2019,1,1)+31&"|",10)&
 REPT(DATE(2019,1,1)+32&"|",10)&REPT(DATE(2019,1,1)+33&"|",10)&REPT(DATE(2019,1,1)+34&"|",10)&
 REPT(DATE(2019,1,1)+35&"|",10)&REPT(DATE(2019,1,1)+36&"|",10)&REPT(DATE(2019,1,1)+37&"|",10)&
 REPT(DATE(2019,1,1)+38&"|",10)&REPT(DATE(2019,1,1)+39&"|",10)&REPT(DATE(2019,1,1)+40&"|",10)&
 REPT(DATE(2019,1,1)+41&"|",10)&REPT(DATE(2019,1,1)+42&"|",10)&REPT(DATE(2019,1,1)+43&"|",10)&
 REPT(DATE(2019,1,1)+44&"|",10)&REPT(DATE(2019,1,1)+45&"|",10)&REPT(DATE(2019,1,1)+46&"|",10)&
 REPT(DATE(2019,1,1)+47&"|",10)&REPT(DATE(2019,1,1)+48&"|",10)&REPT(DATE(2019,1,1)+49&"|",10)&
 REPT(DATE(2019,1,1)+50&"|",10)&REPT(DATE(2019,1,1)+51&"|",10)&REPT(DATE(2019,1,1)+52&"|",10)&
 REPT(DATE(2019,1,1)+53&"|",10)&REPT(DATE(2019,1,1)+54&"|",10)&REPT(DATE(2019,1,1)+55&"|",10)&
 REPT(DATE(2019,1,1)+56&"|",10)&REPT(DATE(2019,1,1)+57&"|",10)&REPT(DATE(2019,1,1)+58&"|",10)&
 REPT(DATE(2019,1,1)+59&"|",10)&REPT(DATE(2019,1,1)+60&"|",10)&REPT(DATE(2019,1,1)+61&"|",10)&
 REPT(DATE(2019,1,1)+62&"|",10)&REPT(DATE(2019,1,1)+63&"|",10)&REPT(DATE(2019,1,1)+64&"|",10)&
 REPT(DATE(2019,1,1)+65&"|",10)&REPT(DATE(2019,1,1)+66&"|",10)&REPT(DATE(2019,1,1)+67&"|",10)&
 REPT(DATE(2019,1,1)+68&"|",10)&REPT(DATE(2019,1,1)+69&"|",10)&REPT(DATE(2019,1,1)+70&"|",10)&
 REPT(DATE(2019,1,1)+71&"|",10)&REPT(DATE(2019,1,1)+72&"|",10)&REPT(DATE(2019,1,1)+73&"|",10)&
 REPT(DATE(2019,1,1)+74&"|",10)&REPT(DATE(2019,1,1)+75&"|",10)&REPT(DATE(2019,1,1)+76&"|",10)&
 REPT(DATE(2019,1,1)+77&"|",10)&REPT(DATE(2019,1,1)+78&"|",10)&REPT(DATE(2019,1,1)+79&"|",10)&
 REPT(DATE(2019,1,1)+80&"|",10)&REPT(DATE(2019,1,1)+81&"|",10)&REPT(DATE(2019,1,1)+82&"|",10)&
 REPT(DATE(2019,1,1)+83&"|",10)&REPT(DATE(2019,1,1)+84&"|",10)&REPT(DATE(2019,1,1)+85&"|",10)&
 REPT(DATE(2019,1,1)+86&"|",10)&REPT(DATE(2019,1,1)+87&"|",10)&REPT(DATE(2019,1,1)+88&"|",10)&
 REPT(DATE(2019,1,1)+89&"|",10)&REPT(DATE(2019,1,1)+90&"|",10)&REPT(DATE(2019,1,1)+91&"|",10)&
 REPT(DATE(2019,1,1)+92&"|",10)&REPT(DATE(2019,1,1)+93&"|",10)&REPT(DATE(2019,1,1)+94&"|",10)&
 REPT(DATE(2019,1,1)+95&"|",10)&REPT(DATE(2019,1,1)+96&"|",10)&REPT(DATE(2019,1,1)+97&"|",10)&
 REPT(DATE(2019,1,1)+98&"|",10)&REPT(DATE(2019,1,1)+99&"|",10)&REPT(DATE(2019,1,1)+100&"|",10)&
 REPT(DATE(2019,1,1)+101&"|",10)&REPT(DATE(2019,1,1)+102&"|",10)&REPT(DATE(2019,1,1)+103&"|",10)&
 REPT(DATE(2019,1,1)+104&"|",10)&REPT(DATE(2019,1,1)+105&"|",10)&REPT(DATE(2019,1,1)+106&"|",10)&
 REPT(DATE(2019,1,1)+107&"|",10)&REPT(DATE(2019,1,1)+108&"|",10)&REPT(DATE(2019,1,1)+109&"|",10)&
 REPT(DATE(2019,1,1)+110&"|",10)&REPT(DATE(2019,1,1)+111&"|",10)&REPT(DATE(2019,1,1)+112&"|",10)&
 REPT(DATE(2019,1,1)+113&"|",10)&REPT(DATE(2019,1,1)+114&"|",10)&REPT(DATE(2019,1,1)+115&"|",10)&
 REPT(DATE(2019,1,1)+116&"|",10)&REPT(DATE(2019,1,1)+117&"|",10)&REPT(DATE(2019,1,1)+118&"|",10)&
 REPT(DATE(2019,1,1)+119&"|",10)&REPT(DATE(2019,1,1)+120&"|",10)&REPT(DATE(2019,1,1)+121&"|",10)&
 REPT(DATE(2019,1,1)+122&"|",10)&REPT(DATE(2019,1,1)+123&"|",10)&REPT(DATE(2019,1,1)+124&"|",10)&
 REPT(DATE(2019,1,1)+125&"|",10)&REPT(DATE(2019,1,1)+126&"|",10)&REPT(DATE(2019,1,1)+127&"|",10)&
 REPT(DATE(2019,1,1)+128&"|",10)&REPT(DATE(2019,1,1)+129&"|",10)&REPT(DATE(2019,1,1)+130&"|",10)&
 REPT(DATE(2019,1,1)+131&"|",10)&REPT(DATE(2019,1,1)+132&"|",10)&REPT(DATE(2019,1,1)+133&"|",10)&
 REPT(DATE(2019,1,1)+134&"|",10)&REPT(DATE(2019,1,1)+135&"|",10)&REPT(DATE(2019,1,1)+136&"|",10)&
 REPT(DATE(2019,1,1)+137&"|",10)&REPT(DATE(2019,1,1)+138&"|",10)&REPT(DATE(2019,1,1)+139&"|",10)&
 REPT(DATE(2019,1,1)+140&"|",10)&REPT(DATE(2019,1,1)+141&"|",10)&REPT(DATE(2019,1,1)+142&"|",10)&
 REPT(DATE(2019,1,1)+143&"|",10)&REPT(DATE(2019,1,1)+144&"|",10)&REPT(DATE(2019,1,1)+145&"|",10)&
 REPT(DATE(2019,1,1)+146&"|",10)&REPT(DATE(2019,1,1)+147&"|",10)&REPT(DATE(2019,1,1)+148&"|",10)&
 REPT(DATE(2019,1,1)+149&"|",10)&REPT(DATE(2019,1,1)+150&"|",10)&REPT(DATE(2019,1,1)+151&"|",10)&
 REPT(DATE(2019,1,1)+152&"|",10)&REPT(DATE(2019,1,1)+153&"|",10)&REPT(DATE(2019,1,1)+154&"|",10)&
 REPT(DATE(2019,1,1)+155&"|",10)&REPT(DATE(2019,1,1)+156&"|",10)&REPT(DATE(2019,1,1)+157&"|",10)&
 REPT(DATE(2019,1,1)+158&"|",10)&REPT(DATE(2019,1,1)+159&"|",10)&REPT(DATE(2019,1,1)+160&"|",10)&
 REPT(DATE(2019,1,1)+161&"|",10)&REPT(DATE(2019,1,1)+162&"|",10)&REPT(DATE(2019,1,1)+163&"|",10)&
 REPT(DATE(2019,1,1)+164&"|",10)&REPT(DATE(2019,1,1)+165&"|",10)&REPT(DATE(2019,1,1)+166&"|",10)&
 REPT(DATE(2019,1,1)+167&"|",10)&REPT(DATE(2019,1,1)+168&"|",10)&REPT(DATE(2019,1,1)+169&"|",10)&
 REPT(DATE(2019,1,1)+170&"|",10)&REPT(DATE(2019,1,1)+171&"|",10)&REPT(DATE(2019,1,1)+172&"|",10)&
 REPT(DATE(2019,1,1)+173&"|",10)&REPT(DATE(2019,1,1)+174&"|",10)&REPT(DATE(2019,1,1)+175&"|",10)&
 REPT(DATE(2019,1,1)+176&"|",10)&REPT(DATE(2019,1,1)+177&"|",10)&REPT(DATE(2019,1,1)+178&"|",10)&
 REPT(DATE(2019,1,1)+179&"|",10)&REPT(DATE(2019,1,1)+180&"|",10)&REPT(DATE(2019,1,1)+181&"|",10)&
 REPT(DATE(2019,1,1)+182&"|",10)&REPT(DATE(2019,1,1)+183&"|",10)&REPT(DATE(2019,1,1)+184&"|",10)&
 REPT(DATE(2019,1,1)+185&"|",10)&REPT(DATE(2019,1,1)+186&"|",10)&REPT(DATE(2019,1,1)+187&"|",10)&
 REPT(DATE(2019,1,1)+188&"|",10)&REPT(DATE(2019,1,1)+189&"|",10)&REPT(DATE(2019,1,1)+190&"|",10)&
 REPT(DATE(2019,1,1)+191&"|",10)&REPT(DATE(2019,1,1)+192&"|",10)&REPT(DATE(2019,1,1)+193&"|",10)&
 REPT(DATE(2019,1,1)+194&"|",10)&REPT(DATE(2019,1,1)+195&"|",10)&REPT(DATE(2019,1,1)+196&"|",10)&
 REPT(DATE(2019,1,1)+197&"|",10)&REPT(DATE(2019,1,1)+198&"|",10)&REPT(DATE(2019,1,1)+199&"|",10)&
 REPT(DATE(2019,1,1)+200&"|",10)&REPT(DATE(2019,1,1)+201&"|",10)&REPT(DATE(2019,1,1)+202&"|",10)&
 REPT(DATE(2019,1,1)+203&"|",10)&REPT(DATE(2019,1,1)+204&"|",10)&REPT(DATE(2019,1,1)+205&"|",10)&
 REPT(DATE(2019,1,1)+206&"|",10)&REPT(DATE(2019,1,1)+207&"|",10)&REPT(DATE(2019,1,1)+208&"|",10)&
 REPT(DATE(2019,1,1)+209&"|",10)&REPT(DATE(2019,1,1)+210&"|",10)&REPT(DATE(2019,1,1)+211&"|",10)&
 REPT(DATE(2019,1,1)+212&"|",10)&REPT(DATE(2019,1,1)+213&"|",10)&REPT(DATE(2019,1,1)+214&"|",10)&
 REPT(DATE(2019,1,1)+215&"|",10)&REPT(DATE(2019,1,1)+216&"|",10)&REPT(DATE(2019,1,1)+217&"|",10)&
 REPT(DATE(2019,1,1)+218&"|",10)&REPT(DATE(2019,1,1)+219&"|",10)&REPT(DATE(2019,1,1)+220&"|",10)&
 REPT(DATE(2019,1,1)+221&"|",10)&REPT(DATE(2019,1,1)+222&"|",10)&REPT(DATE(2019,1,1)+223&"|",10)&
 REPT(DATE(2019,1,1)+224&"|",10)&REPT(DATE(2019,1,1)+225&"|",10)&REPT(DATE(2019,1,1)+226&"|",10)&
 REPT(DATE(2019,1,1)+227&"|",10)&REPT(DATE(2019,1,1)+228&"|",10)&REPT(DATE(2019,1,1)+229&"|",10)&
 REPT(DATE(2019,1,1)+230&"|",10)&REPT(DATE(2019,1,1)+231&"|",10)&REPT(DATE(2019,1,1)+232&"|",10)&
 REPT(DATE(2019,1,1)+233&"|",10)&REPT(DATE(2019,1,1)+234&"|",10)&REPT(DATE(2019,1,1)+235&"|",10)&
 REPT(DATE(2019,1,1)+236&"|",10)&REPT(DATE(2019,1,1)+237&"|",10)&REPT(DATE(2019,1,1)+238&"|",10)&
 REPT(DATE(2019,1,1)+239&"|",10)&REPT(DATE(2019,1,1)+240&"|",10)&REPT(DATE(2019,1,1)+241&"|",10)&
 REPT(DATE(2019,1,1)+242&"|",10)&REPT(DATE(2019,1,1)+243&"|",10)&REPT(DATE(2019,1,1)+244&"|",10)&
 REPT(DATE(2019,1,1)+245&"|",10)&REPT(DATE(2019,1,1)+246&"|",10)&REPT(DATE(2019,1,1)+247&"|",10)&
 REPT(DATE(2019,1,1)+248&"|",10)&REPT(DATE(2019,1,1)+249&"|",10)&REPT(DATE(2019,1,1)+250&"|",10)&
 REPT(DATE(2019,1,1)+251&"|",10)&REPT(DATE(2019,1,1)+252&"|",10)&REPT(DATE(2019,1,1)+253&"|",10)&
 REPT(DATE(2019,1,1)+254&"|",10)&REPT(DATE(2019,1,1)+255&"|",10)&REPT(DATE(2019,1,1)+256&"|",10)&
 REPT(DATE(2019,1,1)+257&"|",10)&REPT(DATE(2019,1,1)+258&"|",10)&REPT(DATE(2019,1,1)+259&"|",10)&
 REPT(DATE(2019,1,1)+260&"|",10)&REPT(DATE(2019,1,1)+261&"|",10)&REPT(DATE(2019,1,1)+262&"|",10)&
 REPT(DATE(2019,1,1)+263&"|",10)&REPT(DATE(2019,1,1)+264&"|",10)&REPT(DATE(2019,1,1)+265&"|",10)&
 REPT(DATE(2019,1,1)+266&"|",10)&REPT(DATE(2019,1,1)+267&"|",10)&REPT(DATE(2019,1,1)+268&"|",10)&
 REPT(DATE(2019,1,1)+269&"|",10)&REPT(DATE(2019,1,1)+270&"|",10)&REPT(DATE(2019,1,1)+271&"|",10)&
 REPT(DATE(2019,1,1)+272&"|",10)&REPT(DATE(2019,1,1)+273&"|",10)&REPT(DATE(2019,1,1)+274&"|",10)&
 REPT(DATE(2019,1,1)+275&"|",10)&REPT(DATE(2019,1,1)+276&"|",10)&REPT(DATE(2019,1,1)+277&"|",10)&
 REPT(DATE(2019,1,1)+278&"|",10)&REPT(DATE(2019,1,1)+279&"|",10)&REPT(DATE(2019,1,1)+280&"|",10)&
 REPT(DATE(2019,1,1)+281&"|",10)&REPT(DATE(2019,1,1)+282&"|",10)&REPT(DATE(2019,1,1)+283&"|",10)&
 REPT(DATE(2019,1,1)+284&"|",10)&REPT(DATE(2019,1,1)+285&"|",10)&REPT(DATE(2019,1,1)+286&"|",10)&
 REPT(DATE(2019,1,1)+287&"|",10)&REPT(DATE(2019,1,1)+288&"|",10)&REPT(DATE(2019,1,1)+289&"|",10)&
 REPT(DATE(2019,1,1)+290&"|",10)&REPT(DATE(2019,1,1)+291&"|",10)&REPT(DATE(2019,1,1)+292&"|",10)&
 REPT(DATE(2019,1,1)+293&"|",10)&REPT(DATE(2019,1,1)+294&"|",10)&REPT(DATE(2019,1,1)+295&"|",10)&
 REPT(DATE(2019,1,1)+296&"|",10)&REPT(DATE(2019,1,1)+297&"|",10)&REPT(DATE(2019,1,1)+298&"|",10)&
 REPT(DATE(2019,1,1)+299&"|",10)&REPT(DATE(2019,1,1)+300&"|",10)&REPT(DATE(2019,1,1)+301&"|",10)&
 REPT(DATE(2019,1,1)+302&"|",10)&REPT(DATE(2019,1,1)+303&"|",10)&REPT(DATE(2019,1,1)+304&"|",10)&
 REPT(DATE(2019,1,1)+305&"|",10)&REPT(DATE(2019,1,1)+306&"|",10)&REPT(DATE(2019,1,1)+307&"|",10)&
 REPT(DATE(2019,1,1)+308&"|",10)&REPT(DATE(2019,1,1)+309&"|",10)&REPT(DATE(2019,1,1)+310&"|",10)&
 REPT(DATE(2019,1,1)+311&"|",10)&REPT(DATE(2019,1,1)+312&"|",10)&REPT(DATE(2019,1,1)+313&"|",10)&
 REPT(DATE(2019,1,1)+314&"|",10)&REPT(DATE(2019,1,1)+315&"|",10)&REPT(DATE(2019,1,1)+316&"|",10)&
 REPT(DATE(2019,1,1)+317&"|",10)&REPT(DATE(2019,1,1)+318&"|",10)&REPT(DATE(2019,1,1)+319&"|",10)&
 REPT(DATE(2019,1,1)+320&"|",10)&REPT(DATE(2019,1,1)+321&"|",10)&REPT(DATE(2019,1,1)+322&"|",10)&
 REPT(DATE(2019,1,1)+323&"|",10)&REPT(DATE(2019,1,1)+324&"|",10)&REPT(DATE(2019,1,1)+325&"|",10)&
 REPT(DATE(2019,1,1)+326&"|",10)&REPT(DATE(2019,1,1)+327&"|",10)&REPT(DATE(2019,1,1)+328&"|",10)&
 REPT(DATE(2019,1,1)+329&"|",10)&REPT(DATE(2019,1,1)+330&"|",10)&REPT(DATE(2019,1,1)+331&"|",10)&
 REPT(DATE(2019,1,1)+332&"|",10)&REPT(DATE(2019,1,1)+333&"|",10)&REPT(DATE(2019,1,1)+334&"|",10)&
 REPT(DATE(2019,1,1)+335&"|",10)&REPT(DATE(2019,1,1)+336&"|",10)&REPT(DATE(2019,1,1)+337&"|",10)&
 REPT(DATE(2019,1,1)+338&"|",10)&REPT(DATE(2019,1,1)+339&"|",10)&REPT(DATE(2019,1,1)+340&"|",10)&
 REPT(DATE(2019,1,1)+341&"|",10)&REPT(DATE(2019,1,1)+342&"|",10)&REPT(DATE(2019,1,1)+343&"|",10)&
 REPT(DATE(2019,1,1)+344&"|",10)&REPT(DATE(2019,1,1)+345&"|",10)&REPT(DATE(2019,1,1)+346&"|",10)&
 REPT(DATE(2019,1,1)+347&"|",10)&REPT(DATE(2019,1,1)+348&"|",10)&REPT(DATE(2019,1,1)+349&"|",10)&
 REPT(DATE(2019,1,1)+350&"|",10)&REPT(DATE(2019,1,1)+351&"|",10)&REPT(DATE(2019,1,1)+352&"|",10)&
 REPT(DATE(2019,1,1)+353&"|",10)&REPT(DATE(2019,1,1)+354&"|",10)&REPT(DATE(2019,1,1)+355&"|",10)&
 REPT(DATE(2019,1,1)+356&"|",10)&REPT(DATE(2019,1,1)+357&"|",10)&REPT(DATE(2019,1,1)+358&"|",10)&
 REPT(DATE(2019,1,1)+359&"|",10)&REPT(DATE(2019,1,1)+360&"|",10)&REPT(DATE(2019,1,1)+361&"|",10)&
 REPT(DATE(2019,1,1)+362&"|",10)&REPT(DATE(2019,1,1)+363&"|",10)&REPT(DATE(2019,1,1)+364&"|",10)
 ,"|",1))))

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.