Transpose then Join

[cfrederes1]

Hi,

I'm attempting to make a 'flat' row by the field "TN" below- I can us the crosstab function and receive the output of the highlighted fields but I can't join to bring the correlated MRC and Qty field for every USOC.

INPUT:

DESIRED OUTPUT:

[Qiu]

@cfrederes1 
It can be completed with the combination of Transpose and Cross Tab and not that The duplicated fields names are not allowed.