Creating table with grouping based on unique ID
Good afternoon, comunity,
I am trying to help a friend create a table where data will be pulled from an Excel spreadsheet. The Excel spreadsheet looks as follows:
Report Number Date Title Recommendation Number Recommendation Text Funds
Please see the attached picture for reference.
The outcome should be sorted based on the last five characters of the report number (in descending order), and the date (in ascending order). Additionally, the data should be grouped based on the Report Number, Date, and Title. Finally "open Recommendations and Potential Monetary Benefits" as seen in the picture should be repeated on each page. The full file can be found here.
Now, my question is: Is this even doable in InDesign, and if yes, how?
Thank you in advance.
AdChoices