Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Merged Cells in Source

Hello everyone,


I am using an excel data source for power BI and some cells are merged, when i import it to Power BI, the cells get unmerged and the value null is given. So how can i merge cells in Power BI?


Thanks in advance,

Community Support
Community Support

Hi  @sr12 ,

You can import the data into power bi and merge it through power query.

Create some data:


1. Enter power query through transform data.

2. Select the column you want to merge, right-click the mouse, and select Merge Columns.


3. Result.



Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User
Super User


we can't merge cells in powerbi. Usually we don't suggest to have merged cells in Excel data source, you need to unmerge those cells and restructure the raw data.

The merged cells will generate some null values columns in powerbi, you can also try to delete those columns as well.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources

Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors