Merging Observations Across Longitudinal Dataset

[Zach Brown]

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!

[Zach Brown]

Nevermind, found Reshape!