Select your data: Click any cell within your table.

Go to the Data tab on the Excel ribbon.

In the "Get & Transform Data" group, click on From Table/Range.

1. This will open the Power Query Editor.

In the Power Query Editor, select the columns that represent your months (your 6 month columns).

Go to the Transform tab in the Power Query Editor ribbon (not the Transform group).

Click on Unpivot Columns.

1. Important Note: There are often three options under the "Unpivot Columns" button:

   1. Unpivot Columns: This will unpivot only the columns you have selected. This is usually the one you want if you've selected all the month columns.

   2. Unpivot Other Columns: This will unpivot all columns except the ones you have selected. This is useful if you have many more month columns than geographical heading columns and it's easier to select just the geographical heading column.

   3. Unpivot Only Selected Columns: This is essentially the same as "Unpivot Columns" and just reiterates that only the selected columns will be unpivoted.
      In your case, since you want to keep the geographical compass headings column as is and unpivot the months, you'll likely either:

2. Select the 6 month columns and choose Unpivot Columns.

3. Select only your geographical compass headings column and choose Unpivot Other Columns.

Once you've unpivoted, you'll see your data transformed into three columns. Power Query will typically name them "Attribute" (for your months) and "Value" (for your data). You can double-click on these column headers in Power Query to rename them to something more descriptive like "Month" and "Sales" or "Value".

Finally, go to the Home tab in the Power Query Editor ribbon and click Close & Load to load the transformed data back into a new sheet in your Excel workbook.

Now your data will be in the correct format for easily creating a pivot table!