I am trying to figure our how to convert a list of repeating categories with text after each to a spreadsheet. I copied the format below and want the bold categories in each line (which repeat in each block down the list) to become column headers and the text after the colon for each category to go as a row under the correct column header. Any ideas? Thanks



Category: Administrative
Issue: Information Exchange
Description: It would be desirable to have electronic health information exchange between community hospitals and the correctional facilities.
Impact: Continuity of Care
Departments Affected: All
Scope of Problem: Widespread
Severity: Medium
Possible Solutions: State to consider options for electronic health information exchange.
__________________________________________________ ___________________________________
Category:
Issue:
Description:
Impact:
Departments Affected:
Scope of Problem:
Severity:
Possible Solutions: