Could you please attach your sample data as twbx format.
In your data source screen I would do a custom split on the String field on ';' for the first 5.
Then on the fields that have been split, probably called 'String - Split 1' 'Sting - Split 2'.... Highlight each of these fields, right click and Pivot. Then instead of using the String field in your view, use the new pivoted field.
I guess this options will work only in case of Excel datasources , I have a primary datasource as DB2 and Secondary datasource as Sql server.
Pivot doesn't work with my datasources.
Thanks for your reply.