Hello. I am trying to format my data a certain way but not having much luck. Currently I have data that looks like the following:
CompCode TradePartner Amt
2140 T7320 5.55
2140 T7980 4.03
7320 T2140 7.33
7980 T2140 1.29
And I need to transform it to look like this
CompCode1 TradePartner1 CompCode2 TradePartner2 Amt1 Amt2 Variance
2140 T7320 7320 T2140 5.55 7.33 -1.78
2140 T7980 7980 T2140 4.03 1.29 2.74
Essentially I need to see the CompCode and TradePartner and then the opposite, where the TradeParter and CompCode are reversed on the same line. Hope that makes sense. Any help would be greatly appreciated. Thanks
Solved! Go to Solution.
Thank you so much.