Create table with different formats

[Syndicate_Admin]

Hello:

I think this is something very simple but I haven't been able to solve it, I need to create this table in Power Bi, but I haven't been able to because it has two different types of formats in the same column.
Format 1: Percentage

Format 2: Integer.

How should the structure of the table be in excel to be able to import it or how is it created directly from PowerBi to be able to visualize it like this????

Thank you

Julian P.

[speedramps]

Learn about Pivot and Unpivot here

https://www.youtube.com/watch?v=li0c6R6UpCw

Convert he year columns to rows (2021, 2022, 2023, 2034, 2025, etc)

Then convert the CAPEX, NNS, CAPEX/NNS into columns

Then change the data type of each column.

If you are new to Power BI then learn about “Date Modelling” and don’t be afraid to change the structure of data from a source system to good BI data model.

Thanks for the clear description of the problem with example data. I wish everyone did that!

Remember we are unpaid volunteers, and you have got free expert help which took a lot of effort,
This solution works and does exactly what you asked.
So please quickly click the [accept as solution] and the thumbs up button to leave kudos. 

One question per ticket please. If you need to change or extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you ! 

If you quote @speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.

Please now click the [accept as solution] and the thumbs up button.  Thank you.

[Syndicate_Admin]

I did as you indicated but I still don't get the expected result, I share the base file with you if you can do the tests in that document.

https://we.tl/t-1sUAWe93aj

Pdta: I didn't find how to upload the file I share it through wetransfer