[Solved] Power Query Two Excel Files with No Header Row in Each Files [closed]

by

[ad_1]

  1. Import the data1, first transpose the table, then promote the headers
  2. Import data2 with promoting the headers
  3. Append data1 and data2 as new

Appending

enter image description here

Result

enter image description here

4

[ad_2]

solved Power Query Two Excel Files with No Header Row in Each Files [closed]