Merging CSV files beneath each other with no matching columns

[OKgo]

The windows run command has a wonderful way to stick together multiple CSV files.

http://www.tomnash.eu/how-to-combine-multiple-csv-files-into-one-using-cmd

Is there any way to mimic this in PowerBi? The merge and append features (to me) appear to require matching columns. My CSV files have no matching columns.

File1.csv

HeaderRow1 + 100 rows

File2.csv

HeaderRow2 + 50 rows

Merge.csv

HeaderRow1 + 100 rows + HeaderRow2 + 50 rows (252 rows total)

[v-chuncz-msft]

@OKgo,

You may use Append Queries (Table.Combine) in Query Editor or UNION Function in DAX.

[OKgo]

@v-chuncz-msft Thank you for commenting.

I am afriad my data does not meet this requiremetn for Table.Combine "The tables must all have the same row type structure"

Nor "The two tables must have the same number of columns" for the DAX solution.

Here is a screen shot of 4 CSVs pasted together. Colmn A denotes which CSV they came from. They have no columns in common.

[OKgo]

Bump!