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
Last activity: Feb 1, 2021, 10:59 AM