I would like to shift data found in a column to a row by Key field. I have a table, within a geodatabase, set up similar to what's below.
KEY_ Value 123 Yellow 123 Blue 456 Red 456 Yellow 789 Green 246 Green 246 Orange
I want to create a table that moves the data in the Value field to rows based on the KEY_ field. The result will look like what's below.
KEY_ Value001 Value002 123 Yellow Blue 456 Red Yellow 789 Green 246 Green Orange
Does anyone have an idea of how this can be done? I tried using the Transpose tool Esri offers but it didn't produce the result I'm looking for. I have basic understanding of Python.