transpose values based on mulitple criteria

[mlttkw]

here is my dilemma. I have a dynamic data source that will have the same distinct Names in column a and b and c and the same of occurrences in each column. Across row 1 the values are also static.


the data within will change

in my output I need to match the distinct values from the input to the output and transpose the values accordingly to the output file

I am attaching my example for better depiction...I am playing around with a combination of Match, Index and Transpose and can't quite get the outcome.

PLEASE HELP!!!