Duplicate column via adding a new row in Google Sheets

0
votes

What formula can I use in Google Sheets to achieve this?

December 26, 2018

December 24, 2018

to 

December 26, 2018

December 26, 2018

December 24, 2018

December 24, 2018
1
google-sheetsgoogle-sheets-formula

1 Answers

0
votes

try like this:

=ARRAYFORMULA(TRANSPOSE(TEXT(TO_DATE(SPLIT(QUERY(REPT(
 TO_TEXT(INDIRECT("A1:A"&COUNTA(A1:A))&"♠"), 2), , 999^99), "♠")), "mmmm dd, yyyy")))

0