Data Layout

[kw7669]

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

[mmish · Accepted solution]

You should be able to create the additional columns and join the data to itself:

[kw7669]

Thank you so much.