Best approach is:
Hi Surya,
I would use the Excel import module to import the Excel sheet first.
Then build a loop in which you process the records containing multivalue fields using the combination:
- finding the position of the first semicolon in the string
- use substring to get the seperate value
- do this for both multivalue fields
- now you have all values available to be able to create an entity with the all seperate fields and the association
Kind regards