Forum Discussion
Help creating a column with content from different excel files.
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! ((:
3 Replies
StuartSmithPower Participant
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.
- amitchandak
Super User
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
