Merge two columns into one table

[prashanth0626]

I have two tables

Location

A

B

C

D

E

F

G

 and

Type
1
2
3
4
5
6
7

 I want to join the above in power query to get the resulting table. Each instance of first table joined with each instance of second table. 

Location	Type
A	1
A	2
A	3
A	4
A	5
A	6
A	7
B	1
B	2
B	3
B	4
B	5
B	6
B	7
C	1
C	2
C	3
C	4
C	5
C	6
C	7

[ziyabikram96 · Accepted solution]

Result Table = CROSSJOIN(Table1,Table2)

[ziyabikram96]

create new table and then put the previouse formula with respect to requirements

[prashanth0626]

@Pragati11 i do not have any common fields between the two. I tried all the combinations of merge queries but doesnt give me the required output. 

[Pragati11]

Hi @prashanth0626 ,

Apologies I missed that part. There is an existing thread for your scenario on the forum:

https://community.powerbi.com/t5/Desktop/expand-and-merge-tables-without-identical-columns/m-p/34083...

Thanks,

Pragati

[Pragati11]

HI @prashanth0626 ,

You can achieve this in Power Query Editor in Power BI. Refer this simple document on combining/merging your 2 tables:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data#combine-querie...

Thanks,

Pragati