I have a very large spreadsheet where I data is entered/saved in a very awkward way. I need to reformat the data to something that I can work with.
I've created a very small subset of my data to use to work our way through my problem here, current form on the left, desired form on the right...