Creating a table of all combinations in Excel [Video]

Power Query solution

Let’s assume you have three state codes and four department codes and you want to create a table of all the possible 12 combinations (3 x 4). How do you do it so that it is flexible? i.e. if you add a new state or department it must be easy to update the combination table.

Old Article

Some articles make a greater impression than others. I was recently asked about a magazine article from August 2011.

Someone had changed jobs and needed to be reminded of the rolling 13 month technique.

The congratulations relate to 15 years of Excel Yourself!

Inserting a Blank Row Between Entries in Excel

A sorting solution

Over the years I have had many requests to help people insert blank rows between entries is a list. Apparently there is an import routine that requires it. My normal solution is a macro because it automates the whole process but there is a manual technique that is quick and easy.