Unfortunately, I think because all of the product info is in one row, you will never be able to satisfy all of the various requests. If possible, I would look to reshape the data so that a row contained one truck id and one product type id (plus whatever other data is required). This will allow your users to look at the data in any combination.
I don't know your process but perhaps you could shape the data this way rather than your current process to create the product string. If not, then perhaps there is something that can be done in Tableau to reshape the data. Pivot? I'd be happy to look at some test data and see if I can recommend something more specific.