Importing fields from Excel question
I have this excel sheet where information on over 100 hospitals, 15 departments and (about 20) fields for department specific information is stored.
Hospitals are in rows, the department fields are in columns but they are grouped in blocks of 15 columns for 15 departments.
So the first column defines the hospital, the second to 16th column give the values for field 1 for the 15 departments, 17th til 31st column hold the value for the second field for the departments etc. So in fact there are 3 dimensions put into a 2 dimensional sheet.
In FM I have a table with hospital names (among other fields) and a table for the departments containing one of the 15 department names and the 20 department fields for that specific department. There is a one-to-many relation between hospitals and departments.
Does anyone have an idea how to import the proper values for all fields for each department (of each hospital) from this Excel sheet?