How to extract same data twice from one cell in one sheet to two cells of another sheet of the same workbook?

[Stevekent]

My workbook has 2 worksheets. Worksheet 1 cell A1 contain ABC, cell A2 contain DEF. Now, how can I automatically extract these data to worksheet 2 cell A1 as ABC, cell A2 also ABC, and Cell A3 is DEF, A4 also same DEF

 

[Fluff]

How about

=TOCOL(IF(SEQUENCE(,2),Sheet1!A1:A2))

 

[Stevekent]

How about

=TOCOL(IF(SEQUENCE(,2),Sheet1!A1:A2))

Sorry, not able to solve my problem

 

[Fluff]

In what way?

 

[Rick Rothstein]

Cryptic responses like you gave in Message #12 are not very helpful. With that said (which means I am having to guess here), does this formula do what you want...

=LET(col,Sheet1!A:A,data,FILTER(col,LEN(col)),TOCOL(HSTACK(data,data)))

 

[DanteAmor]

My workbook has 2 worksheets. Worksheet 1 cell A1 contain ABC, cell A2 contain DEF. Now, how can I automatically extract these data to worksheet 2 cell A1 as ABC, cell A2 also ABC, and Cell A3 is DEF, A4 also same DEF

In the other post you duplicated:

How to repeat cell values A1 to B1 and B2, and cell A2 to B3 and B4, etc. Example, A1 value is cat and A2 is dog, and now I want B1 to be cat, B2 also cat, and B3 and B4 to be dog. As I’ve a long list, I need a formula to easily accomplish the task. Please help. Thank you in advance.

I posted this answer. (But my answer was deleted.)

Put the formula in cell B1
Change A5 to the cell with the last data in column A.

=TEXTSPLIT(TEXTJOIN(",",,LET(a,A1:A5,HSTACK(a,a))),,",")

Example: