Need assistance | Row to columns based on a specific value

[udles5666]

Hi Community

I was hoping to get some support to find a solution to the problem I am trying to solve.

I want to populate 'volume' from the measure field as a separate column. Rest all the other measures can stay as it is. Sample packaged workbook is attached and sample output required is below. 

Thanks in advance. Much appreciated. 

Customer_id	material_ID	Country	Version	Measure	Value	Volume
1	456	SP	A	Price	1424.55	284.33
1	456	SP	A	Costs	20517.8	0
1	456	SP	A	Margin	11037.38	0
1	745	ID	A	Price	4416.05	-0.01
1	745	ID	A	Costs	-9480.42	0
1	745	ID	A	Margin	221.55	0

[PangHC]

@udles5666 
for the volume, did you want just one line or apply to all

[udles5666]

Thanks @PangHC - just one line - rest should be 0. Thanks

[PangHC · Accepted solution]

oh. my mistake. I should ask also which measure. but it look like price. 

basically filter out these 2 then process separately.
then union it back to main stream.

[udles5666]

@PangHC  - Thanks - super helpful! :)