How to import multiple lines into one row?

[kznmrexcel]

Hi, everyone,
I have a text file that produces the information below for each record. I need each record on a single row in Excel so that we can sort the information by date. My colleague, Leslie, is in the process of discarding these Chromebooks as they become irreparable through student use, and our circulation software alone will not sort the data by date. This means that Leslie has to wade through all the records of Chromebooks already accounted for to locate the newest ones discarded for her current discard report. All I actually need is the "Barcode: CB2016GV0002" and the "Discarded from inventory on Oct 27, 2017" on the same line, as the other items on this report are not needed. However, putting everything from this record on one row would allow me to later delete what I don't need. I appreciate any help with this!
Thanks,
Karen

CB2016 Google Chromebook
Chromebook 2016 hp
Copy Number: 0002 Vendor: None Accession Date: Sep 16, 2016
Barcode: CB2016GV0002 Purchase Cost: 250.00 Collection: GVMS
Copy policy: Chromebook Replacement Cost: 250.00 Location:
Condition: Unknown
Notes: Discarded from inventory on Oct 27, 2017.

 

[kznmrexcel]

I should have clarified that the information is displayed as shown above in the text file outputted by our circulation software. We can import it as is (or copy/paste it) and then use a formula to put it all onto one line. Any help is much appreciated!