I am tying to separate out two columns from one.

[AVGUser_PBI]

I have a column for cost category ( actual and forecast) and I am trying to create two columns for actual and forecast.

Basically I want to transform the table as shown in the image:

[AVGUser_PBI]

It worked. I didn't realize it was this simple. Thank you!

[rohit_singh · Accepted solution]

Hi @AVGUser_PBI ,

Suppose this is your dataset,

Select column "Cost type" and Click on Transform --> Pivot Column

In the values column, select "amount"

This should give you the desired result.

Kind regards,

Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂