Keep non related columns balnk when expanding a table after merging

newuser17

New Member
Joined
Sep 12, 2018
Messages
13
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.

adls3c.jpg


after expanding

e7nd6d.jpg


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
 
Last edited:

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
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.
 
Upvote 0
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 ?
 
Upvote 0

Forum statistics

Threads
1,213,495
Messages
6,113,992
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top