Sample Header Ad - 728x90

Format data into excel

-2 votes
1 answer
330 views
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: Can someone please assist in resolve this? **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
Asked by Surendar (35 rep)
Feb 1, 2021, 07:26 AM
Last activity: Feb 1, 2021, 10:59 AM