Hi,
I have an excel file with below pivot table:
2016 2015 2014
longitude latitude jan feb march jan feb march jan feb march
city1 12.34 20.1 2 3 4 56 14 22 33 11 10 30 21 11
city2 13.98 40.2 4 5 6 9 12 11 10 12 18 17 18 10
.
.
.
and would like to flatten to:
longitude latitude year month value
city1 12.34 20.1 2016 jan 2
city2 13.98 40.2 2016 jan 4
city1 12.34 20.1 2016 feb 3
city2 13.98 40.2 2016 feb 5
city1 12.34 20.1 2016 march 4
city2 13.98 40.2 2016 march 6
city1 12.34 20.1 2015 jan 56
city2 13.98 40.2 2015 jan 9
and so on.
Can anyone help.
Thanks
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.