Importing an Excel matrix spreadsheet

Discussion created by ChrisG on Sep 11, 2013
Latest reply on Sep 11, 2013 by robmertens

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