AnsweredAssumed Answered

Importing Excel records spanning multiple rows

Question asked by sergiog on Jun 6, 2017
Latest reply on Jun 6, 2017 by bigtom

Hello,

I have a long list of Contacts in Excel format that I want to import into FileMaker.

The main problem is that each record span over multiple rows (up to 20 rows in same cases) and when importing into FM, each row will be considered a single record

Creating new fields for each "lang 1" / "lang 2" is not a vible option as besides being very time consuming it will result in an extremely long row

The original Excel table looks something like this:

 

Vendor NameLang 1
Lang 2ServiceRate
Jonh DoeEnglishChineseA$1.0
ChineseEnglishB

$2.5

FrenchEnglishC$1.00
ItalianEnglishA
Pierre DupontEnglishFrenchB
Russian FrenchA
GermanFrenchD

 

To complicate matters further, the table contains a variety of merged cells...

Is there any "easy" or logical way to accomplish this without having to modify every single record manually?

My knowlege on FM, and DB in general, is rather limited.

Any suggestion will be much appreciated.

Outcomes