Can you bypass Data Interpreter and just suck in the entire spreadsheet? That might prevent some of what you're seeing. Of course, it might also cause a bit of a mess with your data. Any chance you could share a sample of the data you're working with?
Thanks for replying.
I can't figure out how to add an excel attachment here, please find the image of the sample data.
I did try to add the entire table but could not find a way to edit the table and delete the rows which were not required. I am on Tableau desktop and don't have access to Prep (I think)