Hi @CoG, cool macro. I happened to also create a macro for fun which does this very thing. Unlike your macro, mine is iterative, handling each row one at a time, pivoting it, and then outputting it before going on to the next row. I also included the CReW Expect Equal macro into this workflow (not the iterative macro) to test the results against the Excel version. The only extra thing I needed was a Select tool to update the data types and remove the "Original Column Name" field.
This macro assumes the first column is the column that contains the new desired column names and the starting column headers cannot contain any data that will need to be pivoted.
