How to break a column into multiple columns based on the content?

[Anonymous]

Hello community,

I have a problem in transformingin query editor the Table 1 shown below in a way that I can have each section amount values in a separated column (like table 2 shown below), so I can perform row calculations between these.

Can you please let me know how I can transform the Table 1 into Table 2 as shown below?

Thank you.

[AllisonKennedy]

@Anonymous
Please let us know if the solution from @CNENFRNL has worked. If not, please let us know why so we can continue to help.
What 'row calculations' do you want to perform? I don't typically recommend using the Pivot in Power Query for most datasets, and prefer to leave it in flat tabular format to allow the calculations to be performed column by column with DAX.
You can get what you have asked for in a Table visualization in the report view and many of your row calculations can be done using the row context of DAX and filter functions. Let us know more details on what you're trying to achieve as an end result and we can provide more advice.
Cheers!

[CNENFRNL · Accepted solution]

Hi, @Anonymous , all you need to do is to pivot the column Section in Power Query

[Anonymous]

Hi @CNENFRNL,

It looks to work fine! Many thanks for the support!