Split data into columns

Hello. I have a text file that contains book bibliographic information. The file contains informations that looks like this:

=LDR 01215nam 2200289 a 4500
=001 EDZ0000075364
=003 StDuBDS
=005 20120531150050.0
=006 m||||||||d||||||||
=007 cr||||||||||||
=008 091203s2005\\\\enka\\\fo\\\\\001\0\eng\d
=020 \\$a9780191603099 (ebook) :$cNo price
=020 \\$a0191603090 (ebook) :$cNo price
=040 \\$aStDuBDS$cStDuBDS
=050 \4$aB105.M4
=082 04$a121.6'8$222
=100 1\$aDavis, Wayne A.,$d1951-
=245 10$aNondescriptive meaning and reference$h[electronic resource] :$ban ideational semantics /$cWayne A. Davis.
=260 \\$aOxford :$bClarendon,$c2005.
=300 \\$a1 online resource (xiii, 450 p.) :$bill.
=520 8\$aWayne Davis presents a highly original approach to the foundations of semantics, showing how the so-called 'expression' theory of meaning can handle names and other problematic cases of nondescriptive meaning.
=588 \\$aDescription based on print version record.
=504 \\$aIncludes bibliographical references and index.
=650 \0$aMeaning (Philosophy)
=650 \0$aReference (Philosophy)
=776 08$iPrint version$z9780199261659
=856 40$3Oxford scholarship online$uhttp://dx.doi.org/10.1093/0199261652.001.0001


Each book contains the same fields but it is listed this way and separted by an empty row.

I need each line to be in a column so "=LDR" is a column heading, "=001" is a column heading "=003" is a column heading and so on. Can this be done?

I'm attaching a shrunken version of the text file so that you can see how book information is listed. The acutal text files has over 8000 books.

I am also attaching of the desired result in a spreadsheet.

Thanks!
Sonia Duran

That's half of what I needed. Is it possible to have each entry dispay in a separate row?
Please see attched document for farther explanation.

Thanks again.

Ok, I'm attaching the spreadsheet with the first 3 entries on the text file.

I think an easier solution would be with VBA ... are you willing to look at that ?

Originally Posted by SonDur

That's half of what I needed. Is it possible to have each entry dispay in a separate row?
Please see attched document for farther explanation.

Thanks again.

OK. Your column headings are not unique in their respective "LDR" blocks. There are duplicate "650"s with different data.