Power Query: Extract data from table after other rows are filtered

I have a table that has over 130k rows of data (the example attachment was cut down to meet forum standards of 1m). The original source is about 390+ rows multiplied by the number of years since 1990 times the 12 months of the year. I'm looking for the data from only the 12th month of each year, except for the latest year, which is only available for the first 6 months of the year.

In the attachment the resultant table shows the data for the all of the years from 2010 to 2016 but I need a temporary row 2017 that I can populate with the 6th month data alongside the other data. I'd be able to do this with an index/match in a regular table, but I'm trying to use PQ to accomplish this due to the amount of data in the original source and the time it takes to do it in Excel. I'm not M expert so trying to perform this task is hurting my brain...

The attachment was reduced to only June and December data for 2010 - 2017 only. Any assistance is greatly appreciated...

I don't see how the Pivot solution helps. The requirement is that I find the Employment value for each year and the 12th month except for the current year (2017), which only has the 6th month of data available. In the Pivot I would get blank values for the current year.

My Power Query and M skills are very limited so I'm trying to work through the suggestion of a separate query.

Is there any way to replace the Filtered Rows step in the query to one that selects, for each individual year, the maximum value in the Month column? This would result in selecting the 12th month for all years except 2017, where it would select the 6th month?

xlnitwit, this is a perfect approach, and I very much appreciate your help. Thank you...

In my original source, I had nearly a dozen additional calculated columns and I needed to insert your solution into the middle of the mix and, after renaming all the year columns, everything came out great.