Specific text from txt file to Excel

First time user and I would like to be able to retrieve specific lines of text from a TXT file and load into an Excel spreadsheet.

The file I am retrieving the text from has 5 lines of data that repeats several times in the file but each line ends with unique data. I want to be able to drop each line into a separate column in Excel. Example: Line 2 in column one, Line 4 in column two. Then every line that starts the same as Line 2 will go to column one.

Any help to get me started would be much appreciated. Thanks.

You may start with learning the very basics of Powershell first - Getting Started with PowerShell 3.0. There you will learn everything you need.