Data scrubbing in excel using VBA

Have a report in excel that needs to be scrubbed to be easily readable. Vision clicking a command button in a main tab that once clicked using vba, scrubs the entire file and outputs in a new tab, or even existing tab. Attaching an example of what the report looks like before and after a scrubbing session.