joining data in vertical and horizontal formats
I am trying to provide single sources of entry for loan data information that can feed all reports about that data. Currently, the primary source for some of the loan data is entered into an Excel spreadsheet with 'property' as the primary key. This file contains alot of other unrelated data points. The loan data is listed…