How to import multiple lines into one row?

kznmrexcel

Board Regular
Joined
Jun 16, 2010
Messages
86
Office Version
  1. 2016
Platform
  1. MacOS
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.
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
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!
 
Upvote 0

Forum statistics

Threads
1,224,824
Messages
6,181,187
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top