Here is by business use:

We are an online training provider and our LMS currently only offer user profile information via API however, they do offer reoccurring reports by email. I can build customer reports to be sent to an email address at an interval of my choosing. We need to monitor the LMS user transcript data (scores, completions, session time, ect) within the CRM so we then can use it to trigger marketing workflows and customer reporting.

I know that I can import these reports via CSV into the CRM, however each column contains course specific information that does not relate 1 to 1 with the column name and module field. I have attached a sample spreadsheet with information. For instance, the Course Name field will have multiple courses and the other data needs populate based on the course name.

      Example:

            Course Name #1

Any ideas on how I can acomplish this workflow?