Split one row to multiple rows

[AFZAL SOHAIL]

Respected Team;-
I need a formula who split one row contents into multiple rows,
As shown in the below:

Text​	Expected Result​
Text 1 Text2 Text3 Text4 Text5 Text6 Text7​	Text1​
	Text2​
	Text3​
	Text4​
	Text5​
	Text6​
	Text7​

 

[Fluff]

For 2021 how about

Fluff.xlsm
	A	B
1
2	Text 1 Text2 Text3 Text4 Text5 Text6 Text7	Text 1
3		Text2
4		Text3
5		Text4
6		Text5
7		Text6
8		Text7
Sheet6

Cell Formulas
Range	Formula
B2:B8	B2	=FILTERXML("<k><m>"&SUBSTITUTE(A2,CHAR(10),"</m><m>")&"</m></k>","//m")
Dynamic array formulas.

 

[AFZAL SOHAIL]

Thanks a lot Sir,
This formula is working very well,thanks, thanks, thanks.

 

[Fluff]

You're welcome & thanks for the feedback.