Getting values from the increased columns from month to month

[Tunahan]

I have Excel files that include some reports about our facilities, and want to create graphs about them with Power BI.

My Excel columns are increasing month to month like this:

Report Excel of January

Report Excel of February

The new data is entered by columns based. So, If I want to make a graph, I have to select a column. But, the new data will be in the new columns. How can I make a graph for this?

I couldn't find a solution for increased data from column to column.

Also, I created a new table for the month names like this:

But, I couldn't get the values in the columns whose names are in the rows.

Thanx.

[HotChilli · Accepted solution]

In Power Query, Select the Facility column, right-click and Unpivot other columns

[Tunahan]

I've been trying this for two days, thank you so much.