I have an XL sheet set up with zip codes and names of people living in each zip. The layout when sent to me had the zip code listed once at the first name within the zip code and then all the names below the first record for that zip. I need the zip code next to each name. For instance:
48072 Jones I need to change the example to the left to 48072 Jones
Smith 48072 Smith
Gates 48072 Gates
I want to fill the zip code next to each person's name. I've used a variety of copy techniques but this won't help me with 10,000+ records.
Any advice would be appreciated.