Hi community,
I have what seems to be a simple problem but haven't found a simple solution. I want to take 2 columns of data and turn it into 2 rows of data.
Make this:
Look like this:
I will be using the Dynamic Rename tool afterwards to make the 2nd row become my header row, but I need the 1st row in order to union the header and data back together. There are 255 columns.
Any help would be appreciated.
Thanks,
--sue
Solved! Go to Solution.
The Cross Tab tool is what you are looking for. Don't select any columns to group by and use "Name" for the headers and "Value" for the values.
OMG I tried what I thought was every variation of the Cross Tab tool except this one! THANK YOU!!