Merge many columns in one - Power Query

Question

Hello everyone. Can someone help me with this transformation?&nbsp;&nbsp;Fields "1" need to be my columns, and all "2" need to be the rows.&nbsp;Ex:JANEIRO PAGAMENTO&nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp;CODIGO DA VENDA&nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NOME DO CLIENTE18/01/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 116&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MARCOS ESPINDOLA&nbsp; &nbsp;&nbsp;18/01/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 117&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; JUAREZ REZENDE COELHO18/01/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 118&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MECANICA KLEBER18/01/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 119&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DOUGLAS HENRIQUE MARQUES&nbsp;Any idea how do to that?

wdx223_daniel · Answer

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))

Forum Discussion

Merge many columns in one - Power Query

1 Reply

Related content

Merge Column

Merge duplicates data in columns

Merge columns keep null

MERGE QUERIES

Issues with Merged Column