Modifying Excel Created Forecast to fit Power BI

This should and may have a simple solution, but it's hard to wrap my mind around so forgive me if this is child's play. 

I've created a sales forecast in excel that has many different listed vendors in column A and column B-AA are month names that have all the different forecasted sales dollars. I have a different sheet that also forecasts units in this same format. 

What is the simplest way I can bring this forecast report into power bi without completely dismantling the whole thing or creating a headache? 

In power bi I have historically sales and unit data for each of these vendors as well that I would like to compare with. Does this mean I need an ID in my sales forecasting sheet to make a connection once in pbi?