It sounds like you have more columns than the Tableau default of six fields on the Columns shelf. That leads to fields being combined as comma-separated values into a single column. You can modify that value by navigating to Analysis ==> Table Layout == Advanced and changing the Columns from 6 up to a maximum of 16.
Hope that solves it for you.
Thanks for the reply DOH that has sorted it.