In the attached file;
I have a number of tables with yellow titles. All cells in the table are subsets of the titles. I need to get this data to excel such that Column A contains the titles (repeated for each cell entry) and column B contains the cell contents one per cell.
The problem is that some of the tables have titles as the first cell/row of the table whereas the other tables have the title above the table.
I have coded the table data. Where the title is coded it means it is part of the table. Where the title is the original text the title is not part of the table but is normal text just above the table.
I am looking for a macro to transfer this data from word to excel as described in the first para.
Or at least a macro to make all the tables consistent in the layout of the title.