Tableau is not a data-preparation tool. It's always better to have a clean file to start with. However, Tableau offers some simple transformation tools. When you connect to a dataset, you can, for example, use the Data Interpreter, split a column into multiple columns, or pivot your data. Let's see a case for these transformations.
For this section, I created a dataset to clean in Excel, as illustrated here: