How to move

[abardaje]

how to move the let to Right CP column

[abardaje]

here's my real question: Can someone help me on how to move the value from left CP column that has 28 records displayed to right CP column that has 25 records displayed and use the value of the records displayed in right sheet and use the 'CP' column from the left sheet. The reason of this is because after I use 'sum' in summarize tool of ULP and Category I wasn't able to add and 'group by' the CP and this is why I need to include the CP column after I use sum. Please see the attached sample file. 

[binuacs]

@abardaje I think the Find and Replace tool will be use full for your use case

[Robin_McIntosh]

Sounds like a combination of join and union.  How's this?

[Emmanuel_G]

Hi @abardaje ,

One way to achive this easily :

[abardaje]

Thank you all :) My issue has been resolved! :)