'Split payment method column into two columns in Power BI

I have data which has a Payment Method, containing Advance and Royalty in rows. I want to split that in two columns Advance and Royalty.

This is my sample data:

I would like the output as attached in Power BI:

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source