I'm trying to develop a report by loading an Excel file with merged cells (by year and month) into Power BI.
When I load the Excel data, the merged cells are marked as Null, and I don't know how to fill them in before pivoting.
I want to configure it in the following format.
Hi @ericjo
This is more than just merged cells but a case of nested hierarchy as well. You would need to combine the upper and lower hierarchy and use that as the column names, unpivot and then split the combine hierarchy names. There's also a need to fill down due to merged cells. This isn't exactly for beginners but try the attached files.
Hi @ericjo
This is more than just merged cells but a case of nested hierarchy as well. You would need to combine the upper and lower hierarchy and use that as the column names, unpivot and then split the combine hierarchy names. There's also a need to fill down due to merged cells. This isn't exactly for beginners but try the attached files.
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
