Combining 2 data sources with similar field/columns

[Anonymous]

I have two data sources. Both have fields that I would like to combine. The one dataset has an extra column that I would like to show in Dataset 2 called ADO number.

I have aligned the fields as the following.

Data set 1

1. Area Path

2. Assigned to

3. Iteration Path

4. State

5. Title

6. Work Item ID

7. Work Item Type

Data set 2

1. Impacted Area(s)

2. Assignee

3. Project

4. Status

5. Summary

6. Key

7. Request Type

Essentially I want Area Path and Impacted Area(s) to be one column merging all the rows. I can rename the column to a broad term like Area. 

How can I do this?

Thank you!

[amitchandak · Accepted solution]

@Anonymous , In power append, it will add up all columns, Just rename the one you want to append together,

No common column will be added additionally

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