We need customer information for each account. The customer data is highlighted in yellow on the above report.
We also need the data for each of the customer’s investments. This data is highlighted in pink, green and blue on the above report. Note that there are multiple lines of investment data for each customer account.
When we are finished we want one line of data in an Excel spreadsheet for each investment. We want each line to contain both the investment data and the customer data as shown below.