I have a dataset that looks like the following
State City var result
NY Albany population 99,224
NY Albany elevation 141
NY Albany area code 518
NY Albany mayor Kathy Sheehan
NY Buffalo population 256,480
NY Buffalo elevation 600
NY Buffalo area code 716
NY Buffalo mayor Byron Brown
I would like to reorient the data as follows:
State City Population Elevation area_code mayor
NY Albany 99,224 141 518 Kathy Sheehan
NY Buffalo 256,480 600 716 Byron Brown
