VBA: copy a group of multi-paragraph text in each row separated by a number from a txt file

[jaimond]

Copy the group of multi-paragraph text in each row separated by a number (like 1., 4., 2. )in a txt file.
Numbers may appear random.

txt file data looks like
1. Text

Text1

Text1

4. Text

Text1

Text1

Text11
Text12

Text14

Text15

2. Text

Text1

Text1


txt file data looks like
Output Sheet
Cell A2/1. Text |Cell B2/Text1 |Cell C2/Text1
Cell A3/1. Text |Cell B3/Text1 |Cell C3/Text1 | Cell D3/Text11 Text12 | Cell E4/Text14 | Cell F4/Text15
Cell A2/1. Text |Cell B2/Text1 |Cell C3/Text1

 

[jaimond]

Input & Output Corrected:

Apologies for my mistake. It happened as I tried to post it quickly.

I have a text file containing multi-paragraph text
Now I have to Copy the multi-paragraph text separated by a number (like 1., 4., 2. )in a txt file in each row as the given output example.
Numbers may appear random or repeated in the text file.

The Text in the text.txt file looks like the below:
1. Text

Text11111
11111

Text1
11111
11111




4. Text

Text
11111
1122

Text
11111
1122
4444

Where do you live in USA
New York

Text14

Text15

2. Text

Where do you live in USA

Text1Where do you live in USA. Text1Where do you live in USA.


Now I am looking for output in an excel sheet like this:

paragraph1	paragraph2	paragraph3	paragraph4	paragraph5	paragraph6
1. Text	Text11111 11111	Text1 11111 11111
4. Text	Text 11111 1122	Text 11111 1122 4444	Where do you live in USA New York	Text14	Text15
2. Text	Where do you live in USA	Text1Where do you live in USA. Text1Where do you live in USA.