Following is my assumption, I have 4 columns in my raw data - Column Name, Channel, Placement and Content.
I want to use data in "Column Name" as column names and use data in that column cell accordingly to generate "Custom Column".
Is there a way of doing so in Power Query?
I understand a column is expressed in square brackets, but what expression should I use to achieve the above?
Thank you so much for your time and help.
Go to Solution.
Try this custom column from Query Editor
View solution in original post
Didn't know this expression! Work like charm! Thank you!
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!