Dear friends,   How can I average column values of semi-duplicated rows and replace them with only one row?  In the following table (HAVE) the rows A5, A10, B7 and C6 are duplicated. time anomaly A1 42 A2 43 A3 45 A4 48 A5 55 A5 51 A6 65 A7 75 A8 63 A9 50 A10 48 A10 47 A10 51 A10 55 A11 42 A12 44 B1 125 B2 128 B3 125 B4 132 B5 139 B6 141 B7 158 B7 159 B7 161 B7 147 B7 144 B8 150 B9 142 B10 147 B11 122 B12 123 C1 1135 C2 1139 C3 1135 C4 1144 C5 1147 C6 1151 C6 1144 C7 1159 C8 1144 C9 1140 C10 1138 C11 1133 C12 1129   I need only one row of each of those duplicated rows like below: time anomaly A1 42 A2 43 A3 45 A4 48 A5 53 A6 65 A7 75 A8 63 A9 50 A10 50.25 A11 42 A12 44 B1 125 B2 128 B3 125 B4 132 B5 139 B6 141 B7 153.8 B8 150 B9 142 B10 147 B11 122 B12 123 C1 1135 C2 1139 C3 1135 C4 1144 C5 1147 C6 1147.5 C7 1159 C8 1144 C9 1140 C10 1138 C11 1133 C12 1129 ... View more