Can you send your twbx? or data example?
Honestly, the easiest way would be to change your data set to normal:
record Country 1 China 2 India 3 US 4 bal bla bla 5 bla bla bla
Unfortunately, I do not have access to core data and although I could extract and update the records manually it is about 36000 records and growing rapidly, so I don't think that is practical from an upkeep perspective.
I would love to share the dataset, but there are a number of confidential data fields that cannot be shared. The above sample put into excel, even if it is only four records, should model the issue.
Thank you for your help.
it depends on where data is stored. If it is in database, probably you can make custom SQL like this
select country1 from table
select country2 from table
select country3 from table