I have a very long list of books, each book title having a series of fields
(library, author, date etc) below it. At the moment this is just one long
vertical list in word, with line breaks between each book. I wish to turn
this into a Excel table so I can order the data against date/library etc.
Each field has a 2 letter code preceding it, and I can import this into excel
and break out the code into a separate column without difficulty. However,
how do I then get it to lay out the data as a table, instead of a single
multi-thousand item list, using the field code column to ascribe data to
columns?