Transpose One Column Into Multiple Columns with Excel Macro

Say you’ve got a file from someone that is an address list. Name, address, city etc. But it’s all in one column. It’s not separated into different columns to easily do any analysis or mail merge. You need to put it into a table with a name field or address field. This also can apply to other types of one column data or databases. There’s a bunch of ways to transform this type of data, and in this video, I’ll show a quick way to do it by recording a macro. It’s not as scary as it sounds. Heck I’m not VBA expert and I could even do it. And if I can do it, so can you.

Pivot Table Conditional Formatting

Pivot Tables are one of the best analytical tools in Excel. BUT like any other tables in Excel, you can get lost in the numbers and letters, when there’s a lot. And the easiest way to get your point across is with visuals. And that what conditional formatting can do for you. Help you communicate an important message with your data. You don’t always need to create a separate bar or line chart for your data. Even though a Pivot Table is a great analytical tool, sometimes you need an extra push to help highlight data and conditional formatting is something that does that.

Create a Custom Sort in Excel and Power Query

https://youtu.be/7PVjvY4a_V8

You can create a custom list to sort if you don't want to use the ascending (A-Z) or descending (Z-A) sort. If you want to sort North-South-East-West in this order instead of alphabetically (i.e., East-North-South-West), a creating a custom sort will be your solution. This video will show you how it's enable to help analyze Pivot Table data and also if you want to create a custom sort capability in Power Query.