Recognize Headings dynamically

[mlauber71]

We recently had a similar question. Maybe you could benefit from the solution. There always was a table somwhere on an excel sheet and a keyword to identify the line where the header would start.

Loop on the basis of single Excel sheet data

OK it was slightly more complicated than I initially thought. But I hope it does work now: give each line a unique ID to identify them later identify the ‘heads’ of the tables (“FORMNAME”) like you already did use moving aggregate to give the heads unique numbers bring these numbers back to the data fill the intermediate (empty) cells with the head’s number use a group loop on the blocks identified by the head numbers extract the first line as column names make sure empty columns that would ju…