Power BI with Excel Merge Cells

Hey, My question is that how power bi desktop deals with excel merged cells. if an excel file having many merge cells. How do we do data modelling in power query with merge cells or we have to do individual in excel before going in power bi desktop.

Thanks in advance.

Hi @dipeshkumar30

If you load your data with merged cell then power bi will keep the value for the first row of the merged cell and rest will be null. Then in next step you can use fill down option so that you will have same value what you have in the merged cell but repeated for each row.



Thanks a lot sir its working.