Dear Forum,

I have raw data in a single column in a parent-child format. This data with multiple parent & child names in a single column can go to about 3000 lines. Refer the below image:-

capture1.JPG

I want to split the data into 2 columns. With column A having the child name and column B having the corresponding parent name. Refer the below image.

Capture2.JPG

I would request the forum to suggest an excel formula or macro code to make the task easy.
Thanks
Pratap