Transpose specific row to column

[kumarcoolz]

Hello,

I have a table which is updated every day For example, this table would look like:

 

Is there a way to create a query without altering the initial data? 

I want the contents of the column 'Label' to become individual columns. those coulms should have the values of the 'Custom field value'. I have trying googleing but i guess i am missing out on something

This is how I want my data (in a query) to look like in the end:

Is this possible in Power BI

Thank you in advance!

[KVKrishna]

Hi,

I have also same issuse .You have any ideas or solutions in this scenario please assist me.

Best regards,

Venkatakrishna k

[Greg_Deckler]

I'm never any good at these, but @ImkeF is.

[ImkeF · Accepted solution]

It's like @Seward12533 said. Just make sure not to aggregate when pivoting (you have to expand the dialoge and choose "Don't aggregate".

[Seward12533]

Use the Qeury Editor and Pivot Label with Custom field values.