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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Repeat First Value in Field y for Values of x that are the Same
Sorry for not being more clear. The input data is on the left, the output data on the right. This is a case of multiple records per individual (given by field $1). For simplicity, I've just shown a small (most relevant) portion of the data. I'd like to repeat the first value of field $2 in... -
Repeat First Value in Field y for Values of x that are the Same
For every set of i in $1, I'd like to have the first element of $2 appear in the remaining elements of $2. This process would repeat for each i in $1. I.e.: The data looks roughly This is what I'd like to have it look like: like this: 2 30 2 30...
