For example, I have a two column data as below:
1945 23.51952 25.61952 25.91952 23.51957 26.71957 31.2
How do I get a two column data as below, with the left column being the unique numbers: 1945, 1952, 1957, and the second column being the average values of that year:
1945 23.51952 25.01957 28.95
I can write a loop to do this, but think it must have an easier way to do this.
Thank you@
Best Answer