Select Preferred Value from 2 different row values

[JPSeagull]

Hi. I thought my challenge would be simple using a coalescing formula, but I can't resolve my logic. 

I have this sample data in the first table below. My priority is, by each customer and order, to prioritize the weight in kilogram over pounds. For the first customer, Jones, the clerk entered both the kilograms and the conversion to pounds. However, in the final output, I need a column named, "Weight" and if kilograms exists, list that and if not, list pounds. So the final output would look like the second table below.

Customer	Order ID	Item Line	Item Desc	Value
Jones	8030	41	Weight	150
Jones	8030	8817	Weight in kg	68.04
Smith	8031	41	Weight
Smith	8031	8817	Weight in kg	72.02
Johnson	8032	41	Weight	165
Johnson	8032	8817	Weight in kg

Customer	Order ID	Weight
Jones	8030	68.04
Smith	8031	72.02
Johnson	8032	165

Attached is the workflow. This is just sample data, but I think the workflow below is way too basic. Where I am stuck is that I get this and I want to rename the Item Desc to just "Weight" and I need to get the pounds to show for Johnson instead of a null. Any suggestions?

Customer	Order ID	Item Line	Item Desc	Value
Johnson	8032	8817	Weight in kg
Jones	8030	8817	Weight in kg	68.04
Smith	8031	8817	Weight in kg	72.02

[usmanbashir · Accepted solution]

@JPSeagull - see attached workflow. Hope this helps!

**Updated the workflow to have two outputs - not sure which one you wanted.

[JPSeagull · Accepted solution]

@usmanbashir Thank you! I appreciate the two options and casting the string to discern kg or lbs. Very clever.