My table stores the same variable for each year in separate fields - ex. Pop2010, Pop2011, Pop2012. I used the Transpose Fields tool to transpose the years to long format. It transposes as expected except that the Value Field is stored as text.
Is there a way to set this as integer or double?