Creating Y-o-Y percentage change pivot table
Good Afternoon,
Below is a small excerpt of monthly data compiled over the past two years. Would you be able to help me with a formula which may provide me with a monthly year-over-year percentage change for each of the columns? I'm stumped.
| Month |
Run |
OnOff |
Minneapolis |
Minneapolis-UofM |
MSP Airport |
St. Paul |
St. Paul Amtrak |
MOA |
| 1/1/2013 |
711 |
Off |
|
|
3 |
|
|
|
| 1/1/2013 |
711 |
On |
68 |
|
|
|
|
|
| 2/1/2013 |
711 |
On |
76 |
|
3 |
|
|
7 |
| 2/1/2013 |
711 |
Off |
|
|
|
|
|
|
| 3/1/2013 |
711 |
On |
96 |
|
9 |
|
|
19 |
| 3/1/2013 |
711 |
Off |
|
|
3 |
|
|
|
| 2/1/2013 |
712 |
Off |
40 |
|
|
|
|
2 |
| 2/1/2013 |
712 |
On |
|
|
|
|
|
|
| 3/1/2013 |
712 |
Off |
47 |
|
4 |
|
|
12 |
| 1/1/2013 |
712 |
On |
|
|
|
|
|
|
| 1/1/2013 |
712 |
Off |
47 |
|
5 |
|
|
2 |
| 3/1/2013 |
712 |
On |
|
|
|
|
|
|
| 1/1/2012 |
901 |
Off |
|
23 |
|
75 |
3 |
|
| 1/1/2012 |
901 |
On |
101 |
|
|
|
|
|
| 1/1/2013 |
901 |
On |
1 |
4 |
|
|
|
|
| 1/1/2013 |
901 |
Off |
|
|
|
|
|
|
| 2/1/2013 |
901 |
On |
5 |
37 |
5 |
|
|
|
| 2/1/2013 |
901 |
Off |
|
|
|
|
|
|
| 3/1/2013 |
901 |
On |
56 |
50 |
16 |
|
|
|
| 3/1/2013 |
901 |
Off |
|
|
|
|
|
|
| 1/1/2012 |
902 |
Off |
159 |
33 |
|
|
5 |
|
| 1/1/2012 |
902 |
On |
|
|
|
121 |
|
|
| 2/1/2012 |
902 |
Off |
213 |
|
|
|
|
|
| 2/1/2012 |
902 |
On |
|
37 |
|
175 |
1 |
|
| 3/1/2012 |
902 |
Off |
274 |
|
|
|
|
|
| 3/1/2012 |
902 |
On |
|
91 |
|
181 |
2 |
|
| 4/1/2012 |
902 |
Off |
200 |
|
|
|
|
|
| 4/1/2012 |
902 |
On |
|
52 |
|
144 |
4 |
|