Deceased Ministers - Data Manipulation

Combine data across Excel sheets in preparation for import into Indesign for print publication. Here’s a description of the files attached. [login to view URL] - Portion of final page. [login to view URL] - InDesign markup showing data and formatting codes from a similar list. Dir. of Deceased Ministers (Personal).xls - Base data file. Columns used and punctuation needed: D, B C. (F - G); (Note: F and G should print the year only) Dir. of Deceased Ministers (Employment).xls - Data to show where the minister previously served. To join with above, use CORE Yearbook ID. Multiple rows for each needs to be combined in order beginning with most recent—using date started, column E. Columns used and punctuation needed: G, H, I, E; Listing ends with last organization served and then: E-F; Retired: F. (Note: E and F should print the year only)