Hello all,

I'm not sure if there's a simple name for what I'm trying to do, but I think it can be described fairly easily.

The data I have looks like this (note that this is an example, and the # of columns and rows are undefined):

EE1.png

The data I want looks like this

EE2.png

I am looking for the most dummy proof way to automate this sort of transformation. My thought was I'd select the data range, and then run a macro that produces the results I want. Perhaps, though, Excel comes with this sort of functionality, and no VBA solution is required.