Combine data from 1 row to all row

[daicaboy]

Hello,

I have 2 column from 2 file and i want to combine data from 1 row in column 1 to all row of column 2.

Data 1                               

Column 1

A

B

C

 Data 2

Column 2

X

Y

Z

Result

Result

AX

AY

AZ

BX

BY

BZ

CX

CY

CZ

Thank you for your time!

[wdx223_Daniel · Accepted solution]

=List.TransformMany(Data1[Column1],each Data2[Column2],(x,y)=>x&y)

[daicaboy]

Wow, thank you guys, it help me a lot. I appreciate it !

[v-jingzhan-msft · Accepted solution]

Hi @daicaboy 

@wdx223_Daniel 's solution is great with only one step. It can give you the desired result in a list. 

If you have interest in dealing with it with Power Query Editor GUI, you can try the following steps.

1. In "Data 2" query, add a custom column with #"Data 1"[Column 1]. This gives you a list of data from Data 1 query. 

2. Expand the above custom column to new rows. 

3. Add the second custom column to combine values of two columns with &. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[wdx223_Daniel · Accepted solution]

=List.TransformMany(Data1[Column1],each Data2[Column2],(x,y)=>x&y)