Using row data as column names

[primolee]

Hello everyone,

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.

[Zubair_Muhammad · Accepted solution]

@primolee 

Try this custom column from Query Editor

=Record.Field(_,[ColumnName])

[primolee]

Didn't know this expression!  Work like charm!  Thank you!