Transform Text file to Excel

[tjamal1]

Hi 

I have a text file that contains text like this

School 1
(Desc)
5 Harwood Avenue, Unit 205, Ajax ON L1S 2C1
905-420-8641

School 2
(Desc)
1 Rossland Road West, Suite 203, Ajax ON L1Z 1Z2
647-889-4985/905-686-2224

School 3
(Desc)
846 Finley Ave, Unit 846, Ajax, ON L1S 3R8
647-739-1046

I want to transform these text based on the following criteria

1. The First line of every block goes to School Column (e.g School 1, School 2)

2. 2nd Line goes to Description Column

3. 3rd line goes to Address Column

4 4th line goes to the contact number Column

How can I achieve this in Alteryx Designer?

[tjamal1]

Perfect. Thank you for the solution.

Have a good day! 🙂