Change layout of Excel spreadsheet

For each of the pdfs I would like to create an excel spreadsheet that I can then analyse using pivot tables. For the CBI UCITS Funds spreadsheets the columns should be: • Name of UCITS (bold info only) • Date of Authorisation (bold info only) • Management Company (first line ie name of Management Company) • Trustee (first line ie name of Trustee) For CBI Cross Border Firms: • Name of AIFM (Name only, not address) • Entity Status • Entity Sub Status • Country of Authorisation • Date of Commencement For CBI UCITS Mancos: • Name of Management Company (Name only, not address) • Date of Authorisation • Collective Portfolio Management • Individual Portfolio Management • Investment Advice • Safekeeping/Administration For CBI AIF Firms: • Name of AIFM (Name only, not address) • Authorisation Status • Internally Managed • Date of Authorisation • [Tick boxes for the AIFM Activities as headings below (and add any columns that are not in the list below when you come across them] o 1(a) Portfolio management o 1(b) Risk management o 2(a)(i) Administration: legal and fund management accounting services o 2(a)(ii) Administration: customer inquiries o 2(a)(iii) Administration: valuation and pricing, including tax returns o 2(a)(iv) Administration: regulatory compliance monitoring o 2(a)(ix) Administration: record keeping o 2(a)(v) Administration: maintenance of unit-/shareholder register o 2(a)(vi) Administration: distribution of income o 2(a)(vii) Administration: unit/shares issues and redemptions o 2(a)(viii) Administration: contract settlements, including certificate dispatch o 2(b) Marketing o 2(c) Activities related to the assets of alternative investment funds o Individual Portfolio Management o Investment Advice o Receiving and transmitting of orders For CBI MIFID Investment Firms: • Name (no address) • Auth Date • Client Money • Business Services – a column to each number with a tick • Financial Instruments – a column for each number with a tick • Jurisdictions – a column for each country with FOS or FOE (or any other) in the column