Seperate in columns

[azaterol]

Hello everyone,

I have the following table:
ID 1 is input price
and ID 2 is ouputprice.

I want to get two price columns.

If it is an ID 1 line, the prescribed price should be in the line under the entry price, otherwise $0.

The same with ID 2.

initial situation

ID		Date		Price
1		01/01/2020		$5
2		01/05/2020		$10
1		01/10/2020		$4
1		01/20/2020		$6
2		01/21/2020		$5

excepted situation

ID		Date		Input price		output price
1		01/01/2020		$5		$0
2		01/05/2020		$0		$10
1		01/10/2020		$4		$0
1		01/20/2020		$6		$0
2		01/21/2020		$0		$5

Do you have an idea how I can solve this in Power Query?

[Fowmy · Accepted solution]

@azaterol 

You can add two conditional columns as follows

[azaterol]

@Fowmy  thank you. So simple and works great.