Combine data from 1 row to all row

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!