Restructuring data in Excel

It’s always good to see how other people do things. In this screencast, you can look over my shoulder as I work on a common data problem in Excel. In this case, I have a pile of addresses that are stacked vertically. I need to extract the address, city, state, and zip from each of these addresses into a contiguous block.

One the data is transformed, I geocode it and map it, tres easy with our Excel Geocoding Tool.

Unlike most previous screencasts, this is on a separate page as I needed more elbow room to show the transformation process.

Note: Audio quality is bad, that is to say, my keystrokes sound like random gunfire. We’ve never experienced this before, but will get it fixed in the future.