Excel Data Normalization for ERPNext

I need help extracting and normalizing data from Excel sheet for ERPNext. The data includes operations details and materials required.

Requirements:
- Transform wide layout Excel sheets into structured Excel sheets.
- Data should be ready for ERPNext BOM and Operations.

Ideal Skills:
- Proficiency in Excel
- Experience with ERPNext
- Attention to detail and accuracy

Deliverables:
- Excel VBA, Power Query or Python code.

Looking forward to your bids!