transpose values based on multiple lookup criteria

First I would like to thank all of you for providing a service especially to novices like myself. My VB script knowledge is minimal at best and the complicated formulas hurt my head to create. However, I will say once I see the logic I can make sense of it and apply.

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!!!