I have a large number of data in below format as a txt file. As you can see, each line has Title and then path. What is need here is, i need the data to be present next to each other in an excel - something like Title: Path:

**

• Current result

Title:Projects and Ideas

Path:/content/en_us/

Title:buying-guide

Path:/content/en_us/buying-guide

Title:Choose Exterior Paint Colors

Path:/content/en_us/buying-guide/choose-exterior-paint-colors

Title:Water Softener Buying Guide

Path:/content/en_us/buying-guide/water-softener-buying-guide

Title:Presentation Page

Path:/content/en_us/buying-guide/presentation-page

Expected Result

Title:Projects and Ideas Path:/content/en_us/

Title:buying-guide Path:/content/en_us/buying-guide

Title:Choose Exterior Paint Colors Path:/content/en_us/buyingguide/choose

Title:Water Softener Buying Guide Path:/content/en_us/buying-guide/water

Title:Presentation Page Path:/content/en_us/buying-guide/presentation-page