Unpivoting Causing values with the same name to become numbered

[JordanJackson]

Hi there, 

I am working with an excel document which is structured slightly awkwardly for powerbi, that bieng it has double headers. I've followed the steps in the following video:

Dealing with DOUBLE HEADERS in Power BI using UNPIVOT, TRANSPOSE, and FILL DOWN - YouTube

Follwoing these steps it is almost perfect to working, however values with the same name which are the same have been numbered. I think this stems from them being made colom headers, and these not being able to be the same are then numbered. However, when I then unpivot values are then changed to the example format

Example
Example_45
Example_89

Is there a way to stop this from happening?

[JordanJackson · Accepted solution]

As is often the case with powerbi I have managed to solve my issue, by extracting the text before the delimiter, with that being _ only the values original name is kept.

[serpiva64]

Please, can you post some sample data or a imagine of the data, what you obtain and what you need?