I came across an example of unpivoting a table into a tidy format using the R languages and various extension packages. To unpivot from this messy data:
To this tidy data:
You can also do it easily in Easy Data Transform using Gather and a few other standard transforms:
unpivot.transform (4.1 KB)