Combine 2 excel values into 1

[tkozlyk]

Part A has QTY of 2

Part B has QTY of 3

I want a result of B of Qty 5

and A will be removed

So graphically, starts as

PN  QTY

A      2

B      3

and result I want is

PN    QTY

B        5

[wwatson]

This would work for this simple scenario

[tkozlyk · Accepted solution]

Ah - nice - Thanks

Sorry for the late reply - I get pulled into rabbit holes, many times my own doing and may take me days to get back out.

This works well - other problem I just discovered with SUMMARY (I use summary module alot) is that I have to use UNION right after to bring back ALL the fields going into the SUMMARY that I still need.

Terry