Help creating a column with content from different excel files.

[Anonymous]

Hi!

As the title says, I need some help creating a column with content from different excel files.

Basically, what I have is this:

COLUMN A FILE 1	COLUMN A FILE 2	COLUMN A FILE 3
Water	Meat	Bread
Juice	Pork	Cake

And what I need is this:

NEW COLUMN

Water

Juice

Meat

Pork

Bread

Cake

Thank you in advance for all the help! ((:

[Anonymous · Accepted solution]

@Anonymous 

You must rename the 3 columns with the same name can be "Column A", then one the top ribbon use Append Queries as New. 

 Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , When you load it will come into three table.

Use append table

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[StuartSmith]

Select "Transform Data", then "Append Queries as New" and select the tables to want to join.  This will create a new table with all 3 data sources.

Sorry, should have said, import all 3 files into Power Bi.