transpose values based on mulitple criteria
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!!!
|