Using the uploaded Excel workbook, correct all structural

Using the uploaded Excel workbook, correct all structural and data-quality issues that would prevent reliable dashboard analysis. Requirements: 1. Preserve the original raw data in a separate worksheet named 'Original D…

Using the uploaded Excel workbook, correct all structural and data-quality issues that would prevent reliable dashboard analysis.
Requirements:
1. Preserve the original raw data in a separate worksheet named 'Original Data'.
2. Create a cleaned worksheet named 'Clean Data'.
3. Use one clear header row.
4. Remove unnecessary blank rows and columns.
5. Remove merged cells from the analytical dataset.
6. Standardize column names.
7. Standardize date formats.
8. Convert numeric values stored as text into proper numeric values.
9. Standardize category labels where appropriate.
10. Remove duplicates only when they are genuinely duplicate records.
11. Keep legitimate missing values unless there is a justified correction.
12. Separate combined variables into individual columns where necessary.
13. Remove subtotals and summary rows from the raw transactional table.
14. Convert the cleaned dataset into a proper Excel Table.
15. Preserve all meaningful information from the original workbook.
Do not invent or estimate missing business data.
After cleaning, validate the dataset again.
Then create a new downloadable .xlsx workbook containing the corrected tables.
Also include a short summary of:
- what was changed
- what was preserved
- any remaining data-quality limitations

Exact prompt text captured from the public post/author comments on facebook.com/kelasmultimediaofficial. · Attribution: Kelas Multimedia

More Data analysis prompts