Need a Formula to Extract Text and Numbers into Separate List

[Prasad K]

Here is the data to Extract into Separate cells

Data Validation.xlsx
	A
1	APPLE
2	25
3	MANGO
4	30
5	BANANA
6	40
7	ORANGE
8	40
9	PAPAYA
10	45
Sheet7

I need output like this with using by Formula

Data Validation.xlsx
	A	B	C
1	APPLE	APPLE	25
2	25	MANGO	30
3	MANGO	BANANA	40
4	30	ORANGE	40
5	BANANA	PAPAYA	45
6	40
7	ORANGE
8	40
9	PAPAYA
10	45
Sheet7

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1	APPLE	APPLE	25
2	25	MANGO	30
3	MANGO	BANANA	40
4	30	ORANGE	40
5	BANANA	PAPAYA	45
6	40
7	ORANGE
8	40
9	PAPAYA
10	45
11
Input

Cell Formulas
Range	Formula
B1:B7	B1	=IFERROR(INDEX($A$1:$A$10,ROWS(B$1:B1)*2-1),"")
C1:C7	C1	=IFERROR(INDEX($A$1:$A$10,ROWS(B$1:B1)*2),"")

 

[Prasad K]

How about

Fluff.xlsm
	A	B	C
1	APPLE	APPLE	25
2	25	MANGO	30
3	MANGO	BANANA	40
4	30	ORANGE	40
5	BANANA	PAPAYA	45
6	40
7	ORANGE
8	40
9	PAPAYA
10	45
11
Input

Cell Formulas
Range	Formula
B1:B7	B1	=IFERROR(INDEX($A$1:$A$10,ROWS(B$1:B1)*2-1),"")
C1:C7	C1	=IFERROR(INDEX($A$1:$A$10,ROWS(B$1:B1)*2),"")

Thank you so much @Fluff Sir

 

[Fluff]

You're welcome & thanks for the feedback.