Forum Discussion
Merge many columns in one - Power Query
Hello everyone. Can someone help me with this transformation? Fields "1" need to be my columns, and all "2" need to be the rows. Ex: JANEIRO PAGAMENTO | CODIGO DA VENDA ...
import you data without headers, ie the column names will be Column1, Column2,.....
then add the code in your new step
=Table.PromoteHeaders(Table.Transpose(PreviousStepName))