Dear Experts,
Kindly help me please,
I have a big file where there is duplicate values in col 11 till col 23, every 2 rows appers a new numbers, but in each row there is different coordinates x and y in col 57 till col 74.
Please i will like to get a single value and average of the x and y coordinates.
Example
Imput file
A 25235.0 21449.012 7 75 1 -3162771 77 43 23 865933.2 1931450.7 22.5 897 102 1 1T N/A 54000038 0.81383
A 25235.0 21449.012 6 75 1 4163171 79 37 21 865925.2 1931462.8 23.1 897 102 1 P 1T N/A 54000038 0.81383
A 25015.0 20921.01311 75 1 -4153571 75 58 23 857254.8 1920083.9 -22.2 188 103 1 P 1T N/A 54000056 0.81382
A 25015.0 20921.01310 75 2 -4163868 76 36 19 857246.4 1920096.1 -22.2 188 103 1 P 1T N/A 54000056 0.81382
A 25233.0 21449.012 7 75 1 2142770 77 36 25 865970.9 1931408.5 22.9 896 102 1 1T N/A 54000135 0.81383
A 25233.0 21449.012 6 75 1 3122671 78 44 28 865963.9 1931420.0 23.0 896 102 1 1T N/A 54000135 0.81383
A 25013.0 20921.01311 75 1 -4132772 76 61 23 857279.7 1920040.5 -22.0 187 103 1 1T N/A 54000153 0.81382
A 25013.0 20921.01310 75 2 -4122770 77 42 20 857272.1 1920051.7 -22.2 187 103 1 P 1T N/A 54000153 0.81382
A 25011.0 20921.01311 75 1 3195471 76 53 22 857305.0 1919996.0 -21.9 186 103 1 P 1T N/A 54000235 0.81382
A 25011.0 20921.01310 75 2 -4132669 75 38 21 857297.0 1920007.7 -22.1 186 103 1 P 1T N/A 54000235 0.81382
A 25231.0 21449.012 7 75 1 -3122671 78 37 30 865983.2 1931352.7 22.4 964 102 1 1T N/A 54000253 0.81382
A 25231.0 21449.012 6 75 1 -3132571 80 40 26 865977.8 1931367.7 23.0 964 102 1 1T N/A 54000253 0.81382
desired output
A 25235.0 21449.012 7 75 1 -3162771 77 43 23 865933.2 1931456.6 22.5 897 102 1 1T N/A 54000038 0.81383
A 25015.0 20921.01311 75 1 -4153571 75 58 23 857250.6 1920090.0 -22.2 188 103 1 P 1T N/A 54000056 0.81382
A 25233.0 21449.012 7 75 1 2142770 77 36 25 865967.4 1931414.3 22.9 896 102 1 1T N/A 54000135 0.81383
A 25013.0 20921.01311 75 1 -4132772 76 61 23 857275.9 1920046.1 -22.0 187 103 1 1T N/A 54000153 0.81382
A 25011.0 20921.01311 75 1 3195471 76 53 22 857301.0 1920001.9 -21.9 186 103 1 P 1T N/A 54000235 0.81382
Thanks in advance
Attached file