cancel
Showing results for 
Search instead for 
Did you mean: 

Transform table that has each year as its own column into 1 year column

Highlighted
Image Sensor
Sample of the Current Table. 
Sport 2017 2013 2008 2007 2006 2005 2004
Football 37 39 41 43 43 34 37
Basketball 11 12 9 11 12 12 13
Baseball 9 14 10 13 11 12 10
Soccer 7 4 3 2 2 3 2
Ice hockey 4 3 4 4 2 4 3

Sample of Desired Resulting Table
Sport  Year Value
Football 2017 37
Basketball 2017 11
Baseball 2017 9
Soccer 2017 7
Labels (1)
0 Kudos
2 Replies
Highlighted
Linear Actuator
@marvis2

You'll want to use the Shape->Depivot operation. 

Using your sample data, I used the following transformation to get the desired data structure.  The "REST" button allowed me to select all remaining columns for Values 
Image: https://us.v-cdn.net/6030933/uploads/editor/qd/9ea51h2piivv.png

I hope this helps,
Bill
0 Kudos
Highlighted
Image Sensor
@bstephens
 Thank you so much! That's exactly what I was looking for. 
0 Kudos