ExcelBanter - converting data

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - converting data (https://www.excelbanter.com/new-users-excel/453193-converting-data.html)

Veerapaga Nagendram

converting data

I have bottom topography data for every 200 m distance. Now I want to convert that data into for every 40 m distance. Anyone, please tell me how can I do this?
Thankyou.
my data like this
0 -3
200 -4
400 -5
600 -4.5 and I want to convert it into

0 -3
40
80
..
..
..

killme2008

Your algorithm?
average?

All times are GMT +1. The time now is 03:08 PM.