Forum Discussion
Conditional column in power query
Within power query, how am i able to transform my data to include new columns based on a filtered value of an existing column? I want to recreate the example below Original output ID Type A...
Anonymous,
In Power Query, select the Type column and click Pivot. Choose the settings below:
anmolmalviya05
Super User
Super UserHi Anonymous, You can achieve this using the pivot column feature.
Below is an example:
Check Detailed documentation here: https://support.microsoft.com/en-us/office/pivot-columns-power-query-abc9c8da-3be9-44c4-886e-0be331ab387a
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in