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.

[bebo021999]

Try in A21:

Please Login or Register  to view this content.

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
Copy to C21 and D21
E21

Please Login or Register  to view this content.

Copy to the right.

Copy all down

[Excel Sloth]

bebo02199, greatly thank you sir for taking the time to respond and instruct on this Excel challenge. I look forward to using these strings to get acquainted with INDEX/MATCH. 5 star treatment and 5 star results! Thanks again!