6 Replies Latest reply: May 15, 2014 10:13 AM by MonUserCJ _ RSS

    Good way of processing Excel file that is formatted like report instead of CSV

    MonUserCJ _

      Hey all,

       

      I have an Excel file that is essentially formatted as a report rather than a database. Rather than each row in Excel containing an entire record, an entire record is contained on 4 lines.

       

      Thus, opening it up as a database is problematic, because it assumes one record per line. Is there a handy way to export from Excel so that I can use Monarch to parse the file as a report, or is there a way of using Monarch to recognize that there are 4 rows to a record? I'd appreciate any advice anyone can give.

       

      Thanks.