How to "filter" table to get the velocity of each y value but for a constant x value.

I have 3970*5 matrix, first two columns are the x and y co ordinate and 3rd and 4th columns are the velocities(u,v) and the last column is the reference values. so i want to get the velocity of each y value but for a constant x value.

here are the values

      2.608640, -59.998718, 0.000000, -0.000000, -2
      5.217280, -59.998718, 0.000000, -0.000000, -2
      7.825920, -59.998718, 0.000000, -0.000000, -2
      10.434560, -59.998718, 0.000000, -0.000000, -2
      13.043200, -59.998718, 0.000000, -0.000000, -2
      15.651840, -59.998718, 0.000000, -0.000000, -2
      18.260479, -59.998718, 0.000000, -0.000000, -2
      20.869120, -59.998718, 0.000000, -0.000000, -2
      23.477760, -59.998718, 0.003616, 0.734599, -1
      26.086399, -59.998718, -0.000368, -0.261640, -1
      28.695040, -59.998718, 0.480840, -0.002615, 4
      31.303680, -59.998718, 0.481024, -0.002567, 4
      33.912319, -59.998718, 0.480833, -0.002617, 4
      36.520958, -59.998718, 0.481393, -0.002481, 4
      39.129601, -59.998718, 0.479846, -0.003585, 1
      41.738239, -59.998718, 0.484383, -0.001601, 1
      44.346878, -59.998718, 0.481393, -0.002481, 4
      46.955521, -59.998718, 0.358732, -0.021099, 4
      49.564159, -59.998718, 0.271537, -0.033754, 4
      52.172798, -59.998718, 0.185408, -0.046586, 4
      54.781441, -59.998718, 0.240822, -0.037954, 4
      57.390079, -59.998718, 0.355452, -0.023215, 4
      59.998718, -59.998718, 0.443450, -0.007304, 4
      62.607361, -59.998718, 0.502313, 0.004802, 4
      65.215996, -59.998718, 0.498475, -0.034632, 1
      67.824638, -59.998718, 0.505472, 0.002438, 4
      70.433281, -59.998718, 0.479858, -0.012436, 1
      73.041916, -59.998718, 0.500051, -0.000200, 4
      75.650558, -59.998718, 0.496937, -0.003819, 4
      78.259201, -59.998718, 0.497665, -0.003134, 4
      80.867836, -59.998718, 0.495890, -0.003868, 4
      83.476479, -59.998718, 0.495281, -0.004077, 4
      86.085121, -59.998718, 0.494966, -0.004246, 4
      88.693756, -59.998718, 0.494875, -0.004257, 4
      91.302399, -59.998718, 0.000000, -0.000000, -2
      93.911041, -59.998718, 0.000000, -0.000000, -2
      96.519676, -59.998718, 0.000000, -0.000000, -2
      99.128319, -59.998718, 0.000000, -0.000000, -2
      101.736961, -59.998718, 0.000000, -0.000000, -2
      104.345596, -59.998718, 0.000000, -0.000000, -2
      106.954239, -59.998718, 0.000000, -0.000000, -2
      109.562881, -59.998718, 0.000000, -0.000000, -2
      112.171516, -59.998718, 0.000000, -0.000000, -2
      114.780159, -59.998718, 0.000000, -0.000000, -2
      117.388802, -59.998718, 0.000000, -0.000000, -2
      119.997437, -59.998718, 0.000000, -0.000000, -2
      122.606079, -59.998718, 0.000000, -0.000000, -2
      125.214722, -59.998718, 0.000000, -0.000000, -2
      127.823357, -59.998718, 0.000000, -0.000000, -2
      130.431992, -59.998718, 0.000000, -0.000000, -2
      133.040634, -59.998718, 0.000000, -0.000000, -2
      135.649277, -59.998718, 0.000000, -0.000000, -2
      138.257919, -59.998718, 0.000000, -0.000000, -2
      140.866562, -59.998718, 0.000000, -0.000000, -2
      143.475204, -59.998718, 0.000000, -0.000000, -2
      146.083832, -59.998718, 0.000000, -0.000000, -2
      148.692474, -59.998718, 0.000000, -0.000000, -2
      151.301117, -59.998718, 0.000000, -0.000000, -2
      153.909760, -59.998718, 0.000000, -0.000000, -2
      156.518402, -59.998718, 0.000000, -0.000000, -2
      159.127045, -59.998718, 0.000000, -0.000000, -2
      161.735672, -59.998718, 0.000000, -0.000000, -2
      164.344315, -59.998718, 0.000000, -0.000000, -2
      2.608640, -62.607361, 0.000000, -0.000000, -2
      5.217280, -62.607361, 0.000000, -0.000000, -2
      7.825920, -62.607361, 0.000000, -0.000000, -2
      10.434560, -62.607361, 0.000000, -0.000000, -2
      13.043200, -62.607361, 0.000000, -0.000000, -2
      15.651840, -62.607361, 0.000000, -0.000000, -2
      18.260479, -62.607361, 0.000000, -0.000000, -2
      20.869120, -62.607361, 0.000000, -0.000000, -2
      23.477760, -62.607361, 0.004142, -0.613949, -1
      26.086399, -62.607361, 0.480995, -0.002577, 4
      28.695040, -62.607361, 0.480875, -0.002600, 4
      31.303680, -62.607361, 0.481063, -0.002557, 4
      33.912319, -62.607361, 0.481045, -0.002582, 4
      36.520958, -62.607361, 0.481393, -0.002481, 4
      39.129601, -62.607361, 0.481280, -0.002079, 1
      41.738239, -62.607361, 0.480062, -0.002661, 1
      44.346878, -62.607361, 0.481393, -0.002481, 4
      46.955521, -62.607361, 0.331897, -0.025178, 4
      49.564159, -62.607361, 0.241395, -0.038431, 4
      52.172798, -62.607361, 0.000463, -0.112176, 1
      54.781441, -62.607361, 0.237983, -0.038043, 4
      57.390079, -62.607361, 0.354199, -0.023792, 4
      59.998718, -62.607361, 0.469409, -0.003253, 4
      62.607361, -62.607361, 0.521618, -0.029295, 1
      65.215996, -62.607361, 0.512406, 0.020451, 1
      67.824638, -62.607361, 0.477946, -0.001967, 1
      70.433281, -62.607361, 0.485241, -0.005500, 1
      73.041916, -62.607361, 0.498681, -0.000436, 4
      75.650558, -62.607361, 0.498972, -0.002314, 4
      78.259201, -62.607361, 0.498411, -0.002185, 4
      80.867836, -62.607361, 0.496181, -0.003384, 4
      83.476479, -62.607361, 0.495687, -0.003831, 4
      86.085121, -62.607361, 0.495231, -0.004075, 4
      88.693756, -62.607361, 0.495051, -0.004170, 4
      91.302399, -62.607361, 0.000000, -0.000000, -2
      93.911041, -62.607361, 0.000000, -0.000000, -2
      96.519676, -62.607361, 0.000000, -0.000000, -2
      99.128319, -62.607361, 0.000000, -0.000000, -2
      101.736961, -62.607361, 0.000000, -0.000000, -2
      104.345596, -62.607361, 0.000000, -0.000000, -2
      106.954239, -62.607361, 0.000000, -0.000000, -2
      109.562881, -62.607361, 0.000000, -0.000000, -2
      112.171516, -62.607361, 0.000000, -0.000000, -2
      114.780159, -62.607361, 0.000000, -0.000000, -2
      117.388802, -62.607361, 0.000000, -0.000000, -2
      119.997437, -62.607361, 0.000000, -0.000000, -2
      122.606079, -62.607361, 0.000000, -0.000000, -2
      125.214722, -62.607361, 0.000000, -0.000000, -2
      127.823357, -62.607361, 0.000000, -0.000000, -2
      130.431992, -62.607361, 0.000000, -0.000000, -2
      133.040634, -62.607361, 0.000000, -0.000000, -2
      135.649277, -62.607361, 0.000000, -0.000000, -2
      138.257919, -62.607361, 0.000000, -0.000000, -2
      140.866562, -62.607361, 0.000000, -0.000000, -2
      143.475204, -62.607361, 0.000000, -0.000000, -2
      146.083832, -62.607361, 0.000000, -0.000000, -2
      148.692474, -62.607361, 0.000000, -0.000000, -2
      151.301117, -62.607361, 0.000000, -0.000000, -2
      153.909760, -62.607361, 0.000000, -0.000000, -2
      156.518402, -62.607361, 0.000000, -0.000000, -2
      159.127045, -62.607361, 0.000000, -0.000000, -2
      161.735672, -62.607361, 0.000000, -0.000000, -2
      164.344315, -62.607361, 0.000000, -0.000000, -2
      2.608640, -65.215996, 0.000000, -0.000000, -2
      5.217280, -65.215996, 0.000000, -0.000000, -2
      7.825920, -65.215996, 0.000000, -0.000000, -2
      10.434560, -65.215996, 0.000000, -0.000000, -2
      13.043200, -65.215996, 0.000000, -0.000000, -2
      15.651840, -65.215996, 0.000000, -0.000000, -2
      18.260479, -65.215996, 0.000000, -0.000000, -2
      20.869120, -65.215996, 0.000000, -0.000000, -2
      23.477760, -65.215996, 0.480903, -0.002597, 4
      26.086399, -65.215996, 0.480950, -0.002586, 4
      28.695040, -65.215996, 0.480948, -0.002589, 4
      31.303680, -65.215996, 0.481063, -0.002561, 4
      33.912319, -65.215996, 0.481028, -0.002591, 4
      36.520958, -65.215996, 0.481393, -0.002481, 4
      39.129601, -65.215996, 0.481393, -0.002481, 4
      41.738239, -65.215996, 0.481393, -0.002481, 4
      44.346878, -65.215996, 0.418627, -0.011855, 4
      46.955521, -65.215996, 0.310209, -0.028105, 4
      49.564159, -65.215996, 0.240826, -0.038366, 4
      52.172798, -65.215996, 0.002330, -0.036585, 1
      54.781441, -65.215996, 0.303323, -0.028746, 4
      57.390079, -65.215996, 0.367591, -0.021406, 4
      59.998718, -65.215996, 0.455546, -0.003601, 4
      62.607361, -65.215996, 0.521209, 0.017471, 1
      65.215996, -65.215996, 0.508178, 0.050332, 1
      67.824638, -65.215996, 0.519963, 0.022021, 1
      70.433281, -65.215996, 0.513278, -0.001427, 1
      73.041916, -65.215996, 0.522023, 0.001795, 1
      75.650558, -65.215996, 0.500667, -0.001677, 4
      78.259201, -65.215996, 0.499504, -0.000809, 4
      80.867836, -65.215996, 0.496802, -0.002722, 4
      83.476479, -65.215996, 0.496295, -0.003397, 4
      86.085121, -65.215996, 0.495626, -0.003803, 4
      88.693756, -65.215996, 0.495376, -0.003982, 4
      91.302399, -65.215996, 0.495187, -0.004089, 4
      93.911041, -65.215996, 0.000000, -0.000000, -2
      96.519676, -65.215996, 0.000000, -0.000000, -2
      99.128319, -65.215996, 0.000000, -0.000000, -2
      101.736961, -65.215996, 0.000000, -0.000000, -2
      104.345596, -65.215996, 0.000000, -0.000000, -2
      106.954239, -65.215996, 0.000000, -0.000000, -2
      109.562881, -65.215996, 0.000000, -0.000000, -2
      112.171516, -65.215996, 0.000000, -0.000000, -2
      114.780159, -65.215996, 0.000000, -0.000000, -2
      117.388802, -65.215996, 0.000000, -0.000000, -2
      119.997437, -65.215996, 0.000000, -0.000000, -2
      122.606079, -65.215996, 0.000000, -0.000000, -2
      125.214722, -65.215996, 0.000000, -0.000000, -2
      127.823357, -65.215996, 0.000000, -0.000000, -2
      130.431992, -65.215996, 0.000000, -0.000000, -2
      133.040634, -65.215996, 0.000000, -0.000000, -2
      135.649277, -65.215996, 0.000000, -0.000000, -2
      138.257919, -65.215996, 0.000000, -0.000000, -2
      140.866562, -65.215996, 0.000000, -0.000000, -2
      143.475204, -65.215996, 0.000000, -0.000000, -2
      146.083832, -65.215996, 0.000000, -0.000000, -2
      148.692474, -65.215996, 0.000000, -0.000000, -2
      151.301117, -65.215996, 0.000000, -0.000000, -2
      153.909760, -65.215996, 0.000000, -0.000000, -2
      156.518402, -65.215996, 0.000000, -0.000000, -2
      159.127045, -65.215996, 0.000000, -0.000000, -2
      161.735672, -65.215996, 0.000000, -0.000000, -2
      164.344315, -65.215996, 0.000000, -0.000000, -2

here for one value of x we have 3 values of y and which contains 3 different value of u and v values. please tell me how to do filter so that i can get the values

[Matt J]

You mean you want to combine/average rows with repeated y-values somehow? If so, show us an example of those rows and what they look like combined.

[Image Analyst]

How about grpstats()?

Or what do you mean for a constant x value? Like you want the velocity for x=59.998718 or for x=135.649277 or for some other constant x value?