Sounds to me like the data isn't in need of 'cleaning up' so much as wanting to transpose rows to columns for export back to Excel. Curious why it doesn't just stay in Excel since it's column oriented rather than row oriented anyway. I've never done that if that is what you're after. Seems to me that a crosstab query that you then transfer to excel, perhaps with an intermediate table if the query doesn't transfer well, would be one way. What I know would work would be automation, whereby you outer loop through the table records and inner loop through the fields, writing to a spreadsheet as you go, one cell at a time. Reach the end of the field set and exit the inner loop, advance the record by one and the spreadsheet row by one and repeat for as many records as there are. You don't say what a lot of records is, so can't say how long this would take.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.