Morning!

I'm quite new to Stata (previously worked in R) and I'm having trouble finding the correct commands to use in merging observations across time. To generalize my problem:

Let's say I've got a dataset of Name, Year, and Address of members of a bank. I know that there are duplicates of names because new observations are recorded every year and some members come and go. These data are recorded in a single set, and I'd like to Merge them so that ...
Name Year Address
Zach Brown 2011 123 Sample Rd
Zach Brown 2012 567 Example Dr
Becomes...
Name Year Address Address1
Zach Brown 2011 123 Sample Rd 567 Example Dr
For Year, I'd love to have the first year sequentially that data was recorded and perhaps record the year that the new address was noted in the variable title of the new variable, ala "Address2012"

I realize this is all kinda vague, but appreciate the help!