How to unpivot Excel data into a tidy table

Keep stable identifier columns, unpivot the repeating measure columns into name and value fields, parse the new labels, and verify that the expected row multiplication and aggregate totals are preserved.

Convert month, metric, or category columns into tidy rows while preserving identifier fields and validating row multiplication and totals.