Excel Table not translating well

[CosmicHorse95]

Hello all!

I made a mock up of an excel table that I want to be populating as the years go on, but it doesn't trasnslate well in Power BI because of merged cells.

You can see what I made in Excel, and how it looks in Power BI.Excel TablePower BI Translation

Does anybody have any suggestions for a better way to format this is excel so that it will "translate" properly? Thanks in advance!

[Anonymous · Accepted solution]

I would suggest something like this (sorry, my image embed isn't working):
Excel: https://imgur.com/wk9lCAm

PowerBI: https://imgur.com/nfpGgtr