ChrisG

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

 

FM12A

Outcomes