For those who use Paste Special in excel to transpose your data, this macro replicates that ability. For example, suppose your data is like so:
In excel, you can copy that data and "transpose" it to look like this:
This macro allows you to do the same thing. In some use cases, it's helpful to have the first row of data become the headers after you've transposed it. Checking the Rename Fields box in the macro's configuration will produce a result like this:
If you put it in your macro repository, it's configured to show up in the Transform Category of your Tool Palette.