Power Query Two Excel Files with No Header Row in Each Files

Aldrian Rahman Pradana 0
Viewed 52

i've been trying to combine 2 excel files with same template (no header row). Unique identifier is in the first column. I'm trying to use power query but show no progress. Here's the data data1 data2

I expect output such as output1 output2

I've been trying with power query and it results duplicate values with null data in other columns Power Query Result

Any idea how to merge it? I'm trying to merge other files but i'm using simple one to use the fundamental.

Please kindly advise.

Thanks

powerquery database excel
1 Answers
  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

userhiPt0
Related