Forum Discussion

aoliver's avatar
aoliver
Icon for Helper III rankHelper III
7 years ago

Conditional Renamed Columns

Hi everyone It is possible to change the name of a column in powerQuery depending of the previous name?  I am trying it in advance editor but I cant reach a solution of this, an example would be ve...
Need Help
Tutorial Requests
aoliver's avatar
aoliver
Icon for Helper III rankHelper III
7 years ago

Any ideas? 

Greatings

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

aoliver  You can try unpivoting the columns and then replace the values under Attribute field from FirstName to SecondName, then finally pivot the table again.