Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Match row sequence and average part of column elements
I have a large data that have the following format 1 0.1 0.2 0.4 2 0.1 0.2 0.4 3 1.0 0.2 0.4 10 4.1 0.2 0.4 20 3.1 0.2 0.4 50 2.1 0.2 0.4 31 5.1 0.2 0.4 . . . 366 11.1 0.2 0.4 The first column is a day stamp and i have many columns as a field. The data is not spaced 1 to 366 evenly as you see...
