Power Query - how to use the values of a column as headers for new columns

[GeorgeGiannakis]

Hello Community,

Hope you are well.

I need your help with the below problem that I face.

The below example table shows, for each project, the monetary value it will generate and the benefit category it belongs to. Finally, each benefit category is further allocated to a specific type. Unfortunately, based on the way the table is extracted, the values of the "hard" benefits are grouped under one column. 

I would appreciated if you could help me with sugegsting a way to edit the extracted table in such a way, that it would eventuallly result in the second table (the valuye each hard category to be under the corresponding hard benefit column).

Kind regards,

George

[amitchandak · Accepted solution]

@GeorgeGiannakis , one way is unpivoting, in that you will lose the second column. may you keep a copy of that?

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

Another way is you create calculated columns.  In Dax

new column = if([col] ="Finance",[Value],blank())

[GeorgeGiannakis]

Hello Amit,

Thank you very much for your reply, it worked just fine.

Kind regards,

George