Reformat 20 Excel Sheets

I have roughly 25 Excel workbooks that need to be brought into a single, consistent layout. They have a handful of rows each.

While the files share a similar structure, a few of them use different column headers and some group related data in different ways. Some you will need common sense to extract into the required format.

I already have the target template ready, so the job is to migrate every dataset into that template format without losing any information.

You’ll be mapping mismatched headers, reshuffling columns or blocks of data where necessary, and making sure each final workbook looks and behaves exactly like the template—same header names, sequence, and data types.

Deliverables
• 25 updated Excel files that mirror the template
• A brief change log noting any assumptions or edge cases you encountered

Manual work will be easiest as each file doesn’t have many rows. Some only a couple of rows.

Let me know how soon you can turn this around and any questions you have about the template before starting.

I’ll pay a bonus of a hassle free experience with easy delivery.