Data Consolidation, Data Reorientation

[Excel Sloth]

To the Moderator: My apologies for attempting to add additional information to an original post. So I will start over with a new (although the same) matter. As a side note, Glenn Kennedy assisted me earlier this morning.

Request the expertise of the audience to suggest/instruct this Excel Sloth. I have reasonable Excel skills but lack in VBA and Power Query.

In the Sample spreadsheet, I am trying to take the data set of 13 rows and consolidate and reorient the data as shown in the Desired Outcome format. In other (and better) words, I would like to populate this new format Desired Outcome using the data set to consolidate with fewer rows than the original data set. I anticipate shrinking the 13 rows down to 9 rows using this new format.

Sorry for my confusion.