How to separate text in a single row that is in a heirarchy into separate cells

by |Published October 24, 2019

I have the following Heriarchy of text in one column different rows in excel

Text
Text2
Text3
Text4
Text5
enter image description here
I need to have this separate Text into Column A, Text2 to column B, Text 3 to Column C and Text 4 and 5 to Column D while staying in their respective rows. Is this possible?

Thanks,