Transpose 2 Columns to 2 Rows

Question

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 Answer

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.