Transfer data from list with multiple headings from word to excel
I'm helping someone organize data for an art catalog, and all of the information she has written down so far is in a (extremely long) word document. It looks like this, with even more categories:
Inventory number
IN0001
Title
name1
Date
1948
Inventory number
IN0002
Title
Date
1953
The headings are all repeated, but there is sometimes no text underneath, though there is always a single blank line. Is there a way to transfer this data from this word document to a spreadsheet, with each title becoming a column heading and the information below, if there is any, populating the cell?
|