Forum Discussion
JulioAu
May 26, 2022Copper Contributor
How to calculate or transpose large rainfall data from vertical to horizontal -months as in Picture
Large rainfall data in Column 2 to transpose to months for those years from 1950 to 1981 or more
Riny_van_Eekelen
May 26, 2022Platinum Contributor
JulioAu A pivot table would work for this. See attached.