Rename Column by value of first row (power query editor)

[Anonymous]

Hi,

in my example I want to rename Column2 with the value of the first row of Column 1:

• Column 1
  • Value X
  • Value Y
• Column 2
  • Value AB
  • Value CD

Shoud be changed to

• Column 1
  • Value X
  • Value Y
• Value X
  
  • Value AB
  • Value CD

How can I manage to do that with Excel Power Query Editor?

Thanks for your help.

[AlexisOlson · Accepted solution]

Do a rename column step and use the first row of Column1 as the value to rename.

= Table.RenameColumns(#"Previous Step Name",{{"Column2", #"Previous Step Name"[Column1]{0}}})

[AlexisOlson · Accepted solution]

Do a rename column step and use the first row of Column1 as the value to rename.

= Table.RenameColumns(#"Previous Step Name",{{"Column2", #"Previous Step Name"[Column1]{0}}})

[Anonymous · Accepted solution]

Many thanks. That worked.

[AlexisOlson]

Just FYI, you marked your last comment as the solution. Might be confusing for future readers.