Try Subfield() in your LOAD:
"Case Record Id"
Subfield("Case Reason",';') as "Case Reason"
This will create a record per value. It's often better to not built a cross table as you described above, but if you absolutely need it, you can add GENERIC LOADs
Thank you very much for your timely answer. I am trying this out.
On your last comment, As I have a "case" table which has one line per case record and each case can have multiple reasons, are you suggestion I create another table called "case reason" with the case record id as the join field ?
Sent from my iPhone