Transpose 2 Columns to 2 Rows

[YeahMan]

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

[phottovy · Accepted 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. 

[YeahMan]

OMG I tried what I thought was every variation of the Cross Tab tool except this one! THANK YOU!!