2 Replies Latest reply on Sep 11, 2013 6:59 AM by robmertens

    Importing an Excel matrix spreadsheet


      Dear FMP Gurus


      I have to import a spreadsheet which has been setup as a matrix. It is as follows:

      Down the left side are three columns: Product code, Description, Price.

      Across the top in the first line are branch codes.

      In the middle are the quantities received by each branch. This middle section can scroll from left to right whereas the first three columns stay fixed.


      The data that I want to import into FM is: Product code, Branch code and Quantity


      If there are ten branch codes across the top in the first line, this should equate to ten separate records in FM, except it comes out as one record with ten fields.


      I am stumped


      Thank you


      Chris G