How do you 'clean up' data on Excel before importing it to pivot table?

For example, a row of data can be on Row B on 1 week and Row D on another
week. How can I place all the data in a way that is consistent before
importing the information to pivot table?

Thank you.