Keep non related columns balnk when expanding a table after merging

[newuser17]

hi all,

im new to power query and i am merging tables and expanding relevant columns. is there any way that keep cells / rows of non related columns blank or null when expanding another column ?

please see attached images for clear understanding. i have highlighted few of duplicates happened after expanding.

before expanding.

after expanding

i believe a non GUI method out there but i m not a pro in power query. any help from you genius peoples much appreciated

 

[Matt Allington]

Row 5 is a duplicate of row 4. When you merge tables, it will create a set of data for each row. If the starting rows are duplicated, the results will be duplicated. How about removing the duplicates before you join the tables.

 

[newuser17]

Hi Matt,

Thanks for your reply. If you see the noined data you can there are no duplicates. I have removed duplicates already. But when the join table have more rows than the base table it add rows for the joining table. So the same rows coppied down with existing data.

What im looking for is stop copying and keep the rows blank. Is there any way ?