Transposing Data on Import to FileMaker
I would like to import data that is currently stored in an Excel spreadsheet in the following format:
Where each entry has a unique value in the ID field, V1, V2, V3... are different variables.
One of the problems that we have is that in some instances an entry may have a different set of Variables (say, V5, V6, and V7, or only V1 and V3). In order to convert these data into a relational database, I would like to store them in FileMaker in the following way:
This really isn't a "transpose" operation as in Excel. Rather, it is creating a unique entry for each combination of ID and Variable. Does FileMaker have a simple way to do this operation?