UdemyNewYearPromo.jpg
PaparazziAd-01.jpg

Microsoft Excel Power Query Pivot Column

April 3, 2020

I recently got a question about cleaning up a list of addresses in order to make it useable for a mail merge. The original data looks something like this.

 

It's a pretty simple list of addresses. But, not very useable. The data is in two columns and organized into address blocks. What happens if you want to sort the data by last name, or perform a filter on Region?

 

The data needs to be organized into a list. Something like this...

You've got a couple of options...

 

You can spend the better part of your day using the CUT and PASTE operations to reorganize the data or you can use the Power of Power Query to Pivot the data and clean it up.

 

Download the exercise file and follow along with the video above.

 

ADDRESS LIST: ColumnAddresses-01.XLSX

 

Please reload

Recent Posts

Please reload

Archive

Please reload

Tags

Please reload

FOLLOW

CONTACT

ADDRESS

Pleasant Grove, UT

©2017 by Office Newb